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;
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'
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博客 ” ，链接：https://blog.itpub.net/27165054/viewspace-741344/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
