expdp与impdp

-- SYS用户执行以下脚本
create directory exppump as '/paic/app/oracle/rdbms/op11g/ckm'; -- 根据实际情况修改
Grant read on directory exppump to dbmgr;
Grant write on directory exppump to dbmgr;

-- 在源数据库用户下编辑如下expdp.par文件
userid='/ as sysdba'
DIRECTORY=ckm
DUMPFILE=expdp%U.dmp
filesize=2000m
parallel=5
CONTENT=DATA_ONLY
JOB_NAME=EXPDP_DATA
lOGFILE=EXPDP.LOG
tables=(
COSDATA.auditing_state
COSDATA.interior_payment
)
query=(
COSDATA.auditing_state:"where LCD >= date'2012-05-28' and LCD <= date'2012-08-02'"
COSDATA.interior_payment:"where LCD >= date'2012-05-28' and LCD <= date'2012-08-02'"
)             
-- 执行脚本             
expdp parfile='/paic/app/oracle/rdbms/op11g/ckm/expdp.par'

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/27165054/viewspace-741344/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/27165054/viewspace-741344/