create directory dump_dir as '/u02/dpdata1';
grant read, write on directory dump_dir to ping;
expdp:
expdp ping/ping tables=SERVICE_INFO directory=dump_dir dumpfile=service.dmp query='WHERE id>20'
expdp ping/ping schemas=ping directory=dump_dir dumpfile=service_%U.dmp filesize=2000000000 parallel=4
impdp:
impdp bi/bi dumpfile=service.dmp tables=SERVICE_INFO DIRECTORY=dump_dir REMAP_SCHEMA=ping:bi REMAP_TABLESPACE=ping:bidat
impdp bi/bi dumpfile=service_%U.dmp full=y DIRECTORY=dump_dir parallel=4
impdp bi/bi DIRECTORY=dump_dir network_link=dblk_ping tables=SERVICE_INFO job_name=imp1 logfile=impdp.log PARALLEL=2
impdp支持db link源获取数据并导入本地表或dump文件
exp:
exp ping/ping tables=SERVICE_INFO file=service.dmp log=export.log
exp ping/ping owner=ping file=service.dmp log=export.log
imp:
imp bil/bil file=service.dmp full=y log=import.log
imp bil/bil file=service.dmp fromuser=ping touser=bil log=import.log