DROP DATABASE LINK

Syntax

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 the DROP PUBLIC DATABASE LINK system privilege.

For information on creating database links, see "CREATE DATABASE LINK".

Keywords and Parameters

PUBLIC

must be specified to drop a PUBLIC database link.

dblink

specifies 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. (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 RALPH.)

Example

The following statement drops a private database link named BOSTON:

DROP DATABASE LINK boston;