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
a one-way conduit allowing you to perform DML against remote databases just like you would against a local database
a pointer in the local database that allows you to access objects on a remote database
a schema object in one database that enables you to access objects on another database
a schema object in the local database that enables you to access objects on a remote database
a schema object that causes Oracle to connect to a remote database to access an object there
a string that uniquely identifies to the communication software the location and name of the remote database
An object stored in the local database that identifies a remote database, a communication path to the remote database, and optionally, a username and password for it. Once defined, a database link can be used to perform queries on tables in the remote database. Also called DBlink. In SQL*Plus, you can reference a database link in a DESCRIBE or COPY command.
A pointer that defines a one-way communication path from an Oracle database server to another database server. The link pointer is actually defined as an entry in a data dictionary table. To access the link, you must be connected to the local database that contains the data dictionary entry. A database link connection is one-way in the sense that a client connected to local database A can use a link stored in database A to access information in remote database B, but users connected to database B cannot use the same link to access data in database A. If local users on database B want to access data on database A, then they must define a link that is stored in the data dictionary of database B. The following database links types are supported: private database link in a specific schema of a database. Only the owner of a private database link can use it. public database link for a database. All users in the database can use it.
One-way pointer to a remote Oracle Database. A connection is established when information is requested from the remote database.
An implementation of chaining. The database link behaves like a database but has no persistent storage. Instead, it points to data stored remotely.
An object stored in the local database that identifies a remote database, a communication path to that database, and optionally, a username and password. Once defined, the database link is used to access the remote database. Database links are implicitly used when a reference is made to a global object name in a distributed database. Also called DBlink.
A network object stored in the local database or in the network definition that identifies a remote database, a communication path to that database, and optionally, a username and password. Once defined, the database link is used to access the remote database. A public or private database link from one database to another is created on the local database by a DBA or user. A global database link is created automatically from each database to every other database in a network with Oracle Names. Global database links are stored in the network definition.