Terminator

• Jul 7th, 2005

 

A database link is a pointer in the local database that allows you to access on a remote database.

amit0716

• Sep 8th, 2007

 

A database link (same as linked servers in SQL Server) is an object in one Oracle database that defines a path to another database. They allow you to query remote tables and execute remote procedures residing in an Oracle User on that remote Oracle database.  That way, you can use tables and other objects from that database in a SQL statement that you execute locally.  Say, for example, that you had a table called USER_MASTER in a remote database (ABC), and that you wanted to access that data while connected to your local database (XYZ) and based on the information that you get from that table, you need to decide what your processing logic is going to be. A database link is what you need.  Before creating it, you must collect the following information:

a) A net service name that your local database instance can use to connect to the remote instance, and

b) A valid username and password on the remote database.
The net service name is necessary for every database link.  The username and password that you specify when defining a database link are used to establish the connection to the remote instance.

Jaydeep Galiya

• Oct 28th, 2012

 

Database link is an implementation of chaining.The database link behaves like a database but has no persistent storage.Instead,it points to data stored remotely.

Abhinav

• Nov 5th, 2012

 

a database link is a path to another database with the help of which a user can access the schema objects of later database.

Carlos Andrés Morales Machuca

• Sep 24th, 2014

 

Is a connection with another database, usually other database Oracle, but is possible with other brand using Heterogeneous Services.