Tuesday, 28 January 2020

Clone or Recreate DB link or Duplicate with different name


set long 100000 line 100
col DBMS_METADATA.GET_DDL('DB_LINK',DB.DB_LINK,DB.OWNER) for a100
SELECT DBMS_METADATA.GET_DDL('DB_LINK',db.db_link,db.owner) from dba_db_links db;

use with where clause to avoid erroneous pickup.

No comments:

Post a Comment