A database link is a connection from the Oracle database to another remote database. The remote database can be an Oracle Database or any ODBC-compliant database such as SQL Server or MySQL.
STEP 1: Configure Static Listener
Make entries of both database on tnsnames.ora file
On Source Database
vi
$ORACLE_HOME/network/admin/listener.ora——————–(make both database entry)
vi $ORACLE_HOME/network/admin/tnsnames.ora
On Target Database: Make same entries in
listener.ora and tnsnames.ora file as source database as above. START LISTENER lsnrctl start lsnrctl
status———————————-should be ready Check connection between both database From source ping target and from
target ping source database.
STEP 2:
On source database create schema which you have to backup / you can go with existing schema also. Grant dba permission to schema — it is not necessarygarnt according to your requirement.
STEP 3:ON TARGET DATABASECreate directory
mkdir –p /data/dump_area
SQL> create or replace directory test_dir as ‘/data/dump_area’;
CREATE DATABASE LINK
Connect to target database and from pdb level create Database link
CREATE DATABASE LINK <LinkName> CONNECT TO <User> IDENTIFIED BY <Password> USING<ConnectionString>;
SQL> create database link remote connect to system identified by oracle using ‘pdbprim’;
STEP-4
With the DBlink we did not need to take export it will perform automatically.