Oracle Database Link Tutorials
Examples to create, use, manage and drop them
A Database Link allows you to access data in a remote database as if it
is a local table's data.
The connection can be made to a database hosted on the same machine or
remotely on another server.
When you query data on a different database, you are essentially using
a distributed query.
It is also possible to execute distributed transactions through database
links like insert, update and delete.
The authentication used in a database link is either the link's owner
or a hard-coded username and password, depending on the way the link was
created.
A database link in oracle can be either private (for use only by the link's
owner) or public (accessible to any user with the correct privileges).
Connectivity is established via Sql*Net, using an alias defined in the
local database server's tnsnames.ora
Have a look at the tutorials below to find out more about oracle database
links :
Create oracle database links
Examples of creating database links.
Make use of oracle database links
How to use your fresh database link, syntax for making use of a database
link and closing one.
Drop oracle database link steps
Housekeeping for your unused or invalid database links.
Hide oracle database link complexity
Want to spare yourself the db link syntax in daily use ?
Hide it with a view or a synonym.
Limit oracle database links per session
Adapt the maximum allowable number of database links per session in your
database.
Manage your oracle database links
How many database links are in existence on your database, how many are
in use ?
Troubleshoot oracle database link errors
Read up here to find solutions to common db link setup mistakes and errors.
