|Oracle8i SQL Reference
Release 2 (8.1.6)
SQL Statements (continued), 2 of 30
To remove a database link from the database.
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.
For information on creating database links, see "CREATE DATABASE LINK".
must be specified to drop a
Restriction: You cannot drop a database link in another user's schema and you cannot qualify dblink with the name of a schema. (Periods are permitted in names of database links. Therefore, Oracle interprets the entire name, such as
The following statement drops a private database link named