Query to find the DDL of a database link in Oracle Database
SET LONG 9000
SELECT DBMS_METADATA.GET_DDL(‘DB_LINK’,a.db_link,a.owner) FROM dba_db_links a;
SET LONG 9000
SELECT DBMS_METADATA.GET_DDL(‘DB_LINK’,a.db_link,a.owner) FROM dba_db_links a;
No comments:
Post a Comment