Drop a DBLink

You can drop a DBLink that is no longer required.

Procedure

The syntax for dropping a DBLink is as follows:

DROP DATABASE LINK [IF EXISTS] dblink_name;

Note that:

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

• If IF EXISTS is specified, the system does not return an error even if the DBLink to be dropped does not exist. If IF EXISTS is not specified and the DBLink to be dropped does not exist, the system returns an error.

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

Here is an example:

DROP DATABASE LINK IF EXISTS ob_dblink;

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