exp和expdp的使用

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