- 18 Oct, 2023
- 0 Comments
- 1 Min Read
Perform Export and import with database link.
What is database Link ?
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 DATABASE
Create directory
1 2 | mkdir –p /data/dump_areaSQL> create or replace directory test_dir as ‘/data/dump_area’; |
CREATE DATABASE LINK
Connect to target database and from pdb level create Database link
1 2 3 | 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.
IMPORT STEP
1 | Impdp schemas=u2 directory=test_dir logfile=link_remote.log network_link=remote |
