Site icon An Oracle Spin by Alex Lima

How to extract the DB LINKS DDL with the password

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;
Exit mobile version