By using network_link parameter, we can directly import the data from source database to target database without generating the dump file. This will need a database link between source and target db . Lets’ see the below example.

DEMO:

Objective – Export table dbatest.EMP_TAB from SOURCEDB and import in TARGETDB using network link.

1. Add the tnsentry of SOURCEDB in TARGETDB server. [ ON TARGETDB]

SOURCEDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.20.204.3)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = SOURCEDB)
    )
  )

2. Create the database link pointing to SOURCEDB [ ON TARGETDB]

SQL> connect dbatest
Enter password:
Connected.
SQL> create database link SOURCE connect to system identified by oracle using 'SOURCEDB';

Database link created.

3. Create a directory for the logfile. [ ON TARGETDB]

create directory DUNNING as '/export/home/oracle';

4. Run impdp command on TARGETDB

SYNTAX – >

impdp directory={DIRECTORY_NAME} logfile=test.log tables={TABE_NAME} network_link={DB_LINK_NAME}

impdp directory=DUNNING logfile=test.log tables=dbatest.EMP_TAB network_link=SOURCE

Starting "DBATEST"."SYS_IMPORT_TABLE_01":  dbatest/******** directory=DUNNING logfile=test.log tables=dbatest.EMP_TAB network_link=SOURCE
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 23 MB
Processing object type TABLE_EXPORT/TABLE/TABLE
. . imported "DBATEST"."EMP_TAB"                         175340 rows
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
;;; Import> exit
Job "DBATEST"."SYS_IMPORT_TABLE_01" successfully completed at Mon Jan 23 18:12:05 2017 elapsed 0 00:07:51

 

We have succefully imported(migrated) the table, without generating the export dump.