Oracle7 Server SQL Reference

DROP DATABASE LINK

Purpose

To remove a database link from the database.

Prerequisites

To drop a private database link, the database link must be in your own schema. To drop a PUBLIC database link, you must have DROP PUBLIC DATABASE LINK system privilege.

If you are using Trusted Oracle7 in DBMS MAC mode, your DBMS label must match the database link's creation label or you must satisfy one of the following criteria:

If the database link's creation label is higher than your DBMS label, you must have READUP and WRITEUP system privileges

If the database link's creation label is lower than your DBMS label, you must have WRITEDOWN system privilege.

If the database link's creation label and your DBMS label are not comparable, you must have READUP, WRITEUP, and WRITEDOWN system privileges.

Syntax

Keywords and Parameters

PUBLIC

must be specified to drop a PUBLIC database link.

dblink

specifies the database link to be dropped.

Usage Notes

You cannot drop a database link in another user's schema and you cannot qualify dblink with the name of a schema. Since periods are permitted in names of database links, Oracle7 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 RALPH.

Example

The following statement drops a private database link named BOSTON:

DROP DATABASE LINK boston