Showing posts with label Clone DB link. Show all posts
Showing posts with label Clone DB link. Show all posts

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.