Perform Export and import with database link.

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
  • User AvatarANKUSH THAVALI
  • 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

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’;