Wednesday, November 13, 2013

script to take DDL of the DB link in oracle database?

SELECT DBMS_METADATA.GET_DDL('DB_LINK',a.db_link,a.owner) FROM dba_db_links a;

No comments:

Post a Comment