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.

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