Database Links Posted by MOHAMMED ABDUL HAMEED on 6:52 AM

Database Link  :

A Database Link is a pointer that defines one way communication path from an oracle database server to another database server.

It simply means if we created a database link  'Hyd' from Database X to Database Y then database x can access information from database Y but not Vice versa.

Type of Database Link :

Private Database Link : It can only be access by the user that created the database link.

Public Database Link : All the database users can access that link.

Create a Database Link:

CREATE DATABASE LINK Hyd CONNECT TO scott IDENTIFIED BY tiger USING 'stage';

Drop a Database Link:

DROP DATABASE LINK Hyd;