How to create database link in Oracle

 

A database link is a schema item in one database that allows you to access objects in another database via the use of another database link.

TNS is used to connect two databases together.

CREATE PUBLIC DATABASE LINK "REMOTDB"
 CONNECT TO EMP
 IDENTIFIED BY EMP
 USING 'DBTEST';

All database users will be able to access the public database using this link.

CREATE DATABASE LINK REMOTE
CONNECT TO scott IDENTIFIED BY tiger
USING 'DBTEST';

For the Fixed Database User, a private database link is provided.

Without the use of TNS, a database connection may be established.

CREATE PUBLIC DATABASE LINK DBLINK
 CONNECT TO DBCON
 IDENTIFIED BY DBCON
 USING '118:103.233.199:1521/ORCL';

I hope it's helpful for you. If you have any queries, don't hesitate to contact me.

Name : Muhammad Sahal Qasim

E-mail : s.m.sahal789@gmail.com

Thank you.