database link

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 link types are supported:

 

 

info.gif

See Also: Oracle9i Database Administrator's Guide for further information about creating private and public database links

 

seealso.gif

See Also: Create a Global Database Link to create a global database link in an Oracle Names server