|Oracle® Database SQL Language Reference
11g Release 2 (11.2)
Part Number E17118-03
See Also:CREATE DATABASE LINK for information on creating database links
A private database link must be in your own schema. To drop a
PUBLIC database link, you must have the
LINK system privilege.
You must specify
PUBLIC to drop a
PUBLIC database link.
Specify the name of the database link to be dropped.
Restriction on Dropping Database Links You cannot drop a database link in another user's schema, and you cannot qualify
dblink with the name of a schema, because periods are permitted in names of database links. Therefore, Oracle Database interprets the entire name, such as
ralph.linktosales, as the name of a database link in your schema rather than as a database link named
linktosales in the schema
Dropping a Database Link: Example The following statement drops the public database link named
remote, which was created in "Defining a Public Database Link: Example":
DROP PUBLIC DATABASE LINK remote;