Drop a DBLink

You can drop a DBLink that is no longer required.

Procedure

Syntax for dropping a DBLink:

obclient> DROP DATABASE LINK dblink_name;

Notes:

• To execute this statement, you must have the DROP DATABASE LINK privilege. For information about how to grant user privileges, see Modify user privileges.

• dblink_name specifies the name of the DBLink to be dropped.

Examples:

obclient> DROP DATABASE LINK ob_dblink;
Query OK, 1 row affected

obclient> DROP DATABASE LINK orcl_dblink;
Query OK, 1 row affected

More information

For more information about operations on DBLinks, see the following topics:

• Create a DBLink

• View existing DBLinks

• Use a DBLink to access data in a remote database

• Use a DBLink to modify data in a remote database