客户端备服务器ORACLE,文件在服务器端生成:
expdp u/u@uni directory=expdir dumpfile=expdp_u110712.dmp exclude=statistics logfile=expdp_u110712.log
impdp ul/u directory=expdir dumpfile=expdp_u110712.dmp schemas=u logfile=impdp_u110712.log
按条件:
expdp notify/not@uni parfile=notify.par notify.par directory=expdir dumpfile=expdp_notify_product0713.dmp tables=(alarmmsg) query=(alarmmsg:"where OCCURTIME>to_date('2011-6-1','yyyy-MM-dd')") exclude=statistics logfile=expdp_notify_product0713.log
impdp notify/not directory=expdir dumpfile=expdp_notify_product0713.dmp logfile=impdp_notify_product0713.log
不导某些表:
expdp uni/uni@uni parfile=unionmon.par directory=expdir dumpfile=expdp_unionmon_product110713.dmp exclude=statistics exclude=TABLE:"IN ('PROPERTYTABLEHIS','PROPERTYVALUES','PROPERTYVALUES_OLD')" logfile=expdp_unionmon_product0713.log
impdp uni/uni directory=expdir dumpfile=expdp_unionmon_product110713.dmp logfile=impdp_unionmon_product0713.log
可以单独导出某个分区,但不能排除表分区(本人没实验成功)
|