DROP LINK
Removes
a link from the database.
SYNTAX
| link_name |
Name
of the link you want to remove from the database. |
DESCRIPTION
The DROP
DATABASE LINK command removes an existing public or private database link
the database. To execute the DROP DATABASE LINK command to drop a public
link, you must have DBA or SYSADM security privileges. To execute the
DROP DATABASE LINK command to drop a private link, you must be the link
owner.
A database
link creates a connection to a remote database, providing access to remote
data from your local database. Although you can directly identify remote
databases, links provide additional benefits since they also contain security
information. This allows you to connect to a remote database with a different
user name than you are using in the local database, or connect to a remote
database that you do not have an account in using a public link.
The PUBLIC/PRIVATE
keywords are optional. These keywords specify the type of database link
you want to drop: public or private. Public links are available to all
users in a database, while private links are available only to the user
that creates them. Only users with DBA or SYSADM security privileges can
drop a public database link, and only the user that created a private
database link can drop it. If you do not specify the type of link you
want to drop, DBMaker will try to drop a private link with the name specified
by default.
EXAMPLES
The following
example drops the private link named FieldLink.
DROP PRIVATE DATABASE LINK FieldLink
|
The following
example drops the public link named FieldLink.
DROP PUBLIC DATABASE LINK FieldLink
|
RELATED COMMANDS
<
DROP INDEX | Contents
| DROP REPLICATION >
|
