Import with out Export dump using network Link..............

In the Target Host....


1 . Create a directory OS level and database level.

mkdir /oracle/export/ASSTEST

CREATE DIRECTORY ASSTEST AS '/oracle/export/ASSTEST';

2. Add the tnsentry of source Db.

create public database link ASSTEST CONNECT TO system IDENTIFIED BY asts4sprd using 'ASSTEST_BACKUP';

3.import your schema using below syntax.

 impdp system/manager99 parfile=schema_ASSTEST.par



vi schema_ASSTEST.par
=============================
DIRECTORY=ASSTEST
NETWORK_LINK=ASSTEST
PARALLEL=20
SCHEMAS=ANC_APPL,IR2_ADMIN,
EXCLUDE=STATISTICS
LOGFILE=ASSTEST.log trace=480300
JOB_NAME=ASSTEST1