Drop a DBLink

You can drop a DBLink that is no longer required.

Procedure

The syntax for dropping a DBLink is as follows:

obclient> DROP DATABASE LINK dblink_name;

Observe the following notes:

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

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

Here is an example:

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

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

References

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

• Create a DBLink

• Query existing DBLinks

• Use a DBLink to access data in a remote database

• Use a DBLink to modify data in a remote database