Deletes a database link.

Syntax

DROP [ PUBLIC ] DATABASE LINK name

Description

You can use the DROP DATABASE LINK command to drop existing database links. To run this command on a database link, you must be the owner of the database link.

Parameters

Parameter Description
name The name of a database link to be deleted.
PUBLIC Specifies that name is a public database link.

Examples

Delete public database link whose name is oralink:

DROP PUBLIC DATABASE LINK oralink;

Delete the public database link whose name is edblink:

DROP DATABASE LINK edblink;