Home Oracle Commands

DROP DATABASE LINK

Drop a Database Link.

Syntax:

   DROP [PUBLIC] DATABASE LINK link_name

Restrictions: You cannot drop a database link in another user's schema and you must specify PUBLIC to drop a PUBLIC database link.

"A woman is like your shadow - follow her, she flies;
fly from her, she follows" - Sebastien-Roch Nicolas Chamfort


Related Commands:

CREATE DATABASE LINK

ALTER SESSION CLOSE DATABASE LINK link_name

Related Views:

 DBA_DB_LINKS        ALL_DB_LINKS        USER_DB_LINKS



Back to the Top

Simon Sheppard
SS64.com