

STEP 1: Configure Static Listener
Make entries of both database on tnsnames.ora file
On Source Database
vi
vi
$ORACLE_HOME/network/admin/tnsnames.ora
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.
Â
mkdir –p /data/dump_area SQL> create or replace directory test_dir as ‘/data/dump_area’;
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’;
Impdp schemas=u2 directory=test_dir logfile=link_remote.log network_link=remote