Extracting ddl for db_links

To extract DDLs for database links in order to identify remote db, user account of the remote db.

SQL> SELECT DBMS_METADATA.GET_DDL('DB_LINK',a.db_link,a.owner)||'/' FROM dba_db_links a;

  CREATE DATABASE LINK "DBLINK1"

   CONNECT TO "REMOTE_DB1" IDENTIFIED BY VALUES '05E67A20C0614597BAB8BB5189C5A5207ED

BE3534CDB2D83F1'

   USING 'SERVICE_NAME1.WORLD'

/

  CREATE DATABASE LINK "DBLINK2"

   CONNECT TO "REMOTE_DB2" IDENTIFIED BY VALUES '05987E6F5E6643D409E175098963854A93C

6A5ED139BD1CA96'

   USING 'SERVICE_NAME2.WORLD'

/

  CREATE DATABASE LINK "DBLINK3"

   CONNECT TO "REMOTE_DB3"  IDENTIFIED BY VALUES '05318971FF97A614216D1EBF0F287777B

6270B7ED5307A6E112C1DEA609B7BF021'

   USING 'SERVICE_NAME3.WORLD'

/