Query to take a backup/Details of all database links in oracle

 

SELECT dl.OWNER,DBMS_METADATA.GET_DDL('DB_LINK',dl.DB_LINK,dl.OWNER) FROM dba_db_links dl;

select dl.OWNER,dl.DB_LINK,dl.USERNAME,dl.HOST,CREATED from dba_db_links dl;

DROP Database Links:

drop database link <db_link_name>;              --Needs to run as a specific user (Owner of the db links)

drop public database link <db_link_name>;    --Needs to run as a sys user.