You can drop a DBLink that is no longer needed.
Procedure
The syntax for dropping a DBLink is as follows:
DROP DATABASE LINK [IF EXISTS] dblink_name;
Instructions for using the statement:
To execute this statement, you must have the
DROP DATABASE LINKprivilege. For information about how to grant privileges to users, see Grant privileges directly.IF EXISTS: IfIF EXISTSis specified, no error is returned even if the DBLink to be dropped does not exist. If it is not specified and the DBLink to be dropped does not exist, the system returns an error.dblink_namespecifies the name of the DBLink to be dropped.
Here is an example:
DROP DATABASE LINK IF EXISTS ob_dblink;
References
For more information about DBLinks, see the following topics: