Datapump NETWORK_LINK Option:

I found good option using datapump Network_link which saves lot of time of time avoiding export and diskspace for the export dumps.

Steps to be followed:

Eg: Source Database is ABC ( Production)
      Target  Database is XYZ ( QA)

Prerequisites :

1) Create DB_LINK from XYZ database on QA to ABC Database on Production.
2) Grant  Roles of EXP_FULL_DATABASE and IMP_FULL_DATABASE to target database (XYZ)  and EXP_FULL_DATABASE to Source Database (ABC)

3) Make sure you provide the username & password of Target Database which is QA here in the example.
4) Start the import using network_link option as below.

Syntax:

From Target Database.


impdp userid= usrename/password@targetdb  network_link=ABC.WORLD parfile= ABC.par

Conclusion:

This option works majorly for larger schemas where we cannt afford time for export & ftp and having space issues on the server.


Regards,
Suresh.G