CREATE DATABASE LINK command

CREATE DATABASE LINK command

PURPOSE:
To create a database link. A database link is an object in the
local database that allows you to access objects on a remote
database or to mount a secondary database in read-only mode. The
remote database can be either an Oracle or a non-Oracle database.

SYNTAX:

CREATE [PUBLIC] DATABASE LINK dblink
[CONNECT TO user IDENTIFIED BY password]
[USING 'connect_string']

where:

PUBLIC
creates a public database link available to all users. If you omit
this option, the database link is private and is available only to
you.

dblink
is the complete or partial name of the database link. For
guidelines for naming database links, see the section Referring to
Objects in Remote Databases.

CONNECT TO user
IDENTIFIED BY password
is the username and password used to connect to the remote database.
If you omit this clause, the database link uses the username and
password of each user who uses the database link.

USING
specifies either:

* the database specification of a remote database
* the specification of a secondary database for a read-only
mount.

For information on specifying remote databases, see the SQL*Net
User's Guide for your specific SQL*Net protocol.

Read-only mounts are only available in Trusted Oracle and can only
be specified for public database links.

PREREQUISITES:
To create a private database link, you must have CREATE DATABASE
LINK system privilege. To create a public database link, you must
have CREATE PUBLIC DATABASE LINK system privilege. Also, you must
have CREATE SESSION privilege on a remote database. SQL*Net must be
installed on both the local and remote databases.

SEE:
CREATE SYNONYM, SELECT