Oracle Data Pump (IMPDP) via Network link
I use Oracle's datapump via network link methodology whenever I need to use data pump instead of taking export, copying over dumpfiles, and then doing import. The Data pump via network link method is much simpler. - Create user on SOURCE db to use for network link in TARGET database. CREATE USER ARTISDBA IDENTIFIED BY "Password123$"; GRANT DBA TO ARTISDBA; - Create Database link on target CREATE DATABASE LINK SERVICE_NAME CONNECT TO ARTISDBA IDENTIFIED BY "Password123$" USING 'SERVICE_NAME'; - Copy TNSNAMES entry for source database to target's tnsnames.ora file. - Create directory in TARGET to use for your logfiles. CREATE DIRECTORY dumpdir AS '/orabkup/expdp'; GRANT READ,WRITE ON DIRECTORY dumpdir to PUBLIC; - Run import job on TARGET. You parallelize the job to make it faster. impdp parfile=impdp.par PARFILE contents: DIRECTORY=dumpdir NETWORK_LINK=SERVICE_NAME SCHEMAS='TEST' PARALLEL=4 LOGFILE=impdp_fr...