Here is a simple script to extract the DB Links DDL with the encripted password.
SET LONG 9000 -- to print the complete string SELECT DBMS_METADATA.GET_DDL('DB_LINK',a.db_link,a.owner) FROM dba_db_links a;
Here is a simple script to extract the DB Links DDL with the encripted password.
SET LONG 9000 -- to print the complete string SELECT DBMS_METADATA.GET_DDL('DB_LINK',a.db_link,a.owner) FROM dba_db_links a;