What is database link and explain.....

This document describes us what is database link and how to create it between two databases.

What is database link?

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.

TYPES of database links:

1. Public database link
2. Private  database link
3. Global database link

Public database link:

It is a database-wide link. All users and PL/SQL subprograms in the database can use the link to access database objects in the corresponding remote database.

Private database link:

It is a database link under specific schema of the local database. Only the owner of a private database link or PL/SQL subprograms in the schema can use this link to access database objects in the corresponding remote database.

Global database link:

It is a network-wide link. Users and PL/SQL subprograms in any database can use a global link to access objects in the corresponding remote database.




Thanks for your patience to view this post.......