📋Steps in this guide1/2

Perform Export and import with database link.

STEP 1: Configure Static Listener

oracle configurationintermediate

by OracleDba

13 views

Overview

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) $ORACLE_HOME/network/admin/listener.ora——————–(make both database entry) 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.

Section 2

Code/Command (click line numbers to comment):

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

Comments (0)

Please to add comments

No comments yet. Be the first to comment!