How to extract the DB Links DDL with the encripted password???

Below 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;

Hope this helps as it has helped in alot of times.