|Oracle8i SQL Reference
Release 3 (8.1.7)
Part Number A85397-01
CREATE SYNONYM to DROP ROLLBACK SEGMENT, 15 of 31
LINK statement to remove a database link from the database.
See Also: CREATE DATABASE LINK for information on creating database links
To drop a private database link, the 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: You cannot drop a database link in another user's schema, and you cannot qualify
dblink with the name of a schema. The reason is that periods are permitted in names of database links. Therefore, Oracle 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
The following statement drops a private database link named