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 polarlink
:
DROP DATABASE LINK polarlink;