Wednesday, January 20, 2016

Query to find the DDL of a database link in Oracle Database

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;

No comments: