DROP DATABASE LINK v16

Name

DROP DATABASE LINK Remove a database link.

Synopsis

DROP [ PUBLIC ] DATABASE LINK <name>

Description

DROP DATABASE LINK drops existing database links. To execute this command, you must be a superuser or the owner of the database link.

Parameters

name

The name of a database link to remove.

PUBLIC

Indicates that name is a public database link.

Examples

Remove the public database link named oralink:

DROP PUBLIC DATABASE LINK oralink;

Remove the private database link named edblink:

DROP DATABASE LINK edblink;

See also

CREATE PUBLIC DATABASE LINK