Oracle9i SQL Reference Release 2 (9.2) Part Number A96540-01 |
|
SQL Statements: CREATE TYPE to DROP ROLLBACK SEGMENT, 10 of 26
Use the DROP
DATABASE
LINK
statement to remove a database link from the database.
See Also:
CREATE DATABASE LINK for information on creating database links |
A private database link must be in your own schema. To drop a PUBLIC
database link, you must have the DROP
PUBLIC
DATABASE
LINK
system privilege.
drop_database_link::=
You must specify PUBLIC
to drop a PUBLIC
database link.
Specify the name of the database link to be dropped.
Restriction on database links: You cannot drop a database link in another user's schema, and you cannot qualify dblink with the name of a schema, because 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
.
The following statement drops a private database link named sales.hq.acme.com
:
DROP DATABASE LINK sales.hq.acme.com;
|
Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved. |
|