Skip to content
≡

Administrator

Developer

Tools

External Tools

DROP DATABASE LINK

Syntax#

drop_database_link ::=

Prerequisites#

Only the SYS user or the user granted the DROP DATABASE LINK system privilege can remove a database link object.

Description#

Drops a database link object.

Specifies the name of the database link object to be removed.

Cautions#

If the database link object to be dropped is currently in use, it cannot be dropped. It can only be removed when no queries are being executed through the given database link object. An error will be raised if the database object link is being queried.

Examples#

<Query 1> Drop the PRIVATE database link object, 'dblink'. 

DROP PRIVATE DATABASE LINK dblink1;

<Query 2> Drop the PUBLIC database link object, 'dblink1'. 

DROP PUBLIC DATABASE LINK dblink1;
or 
DROP DATABASE LINK dblink1;