常用数据库逻辑备份语句

来源：互联网发布：雇网络维护人员要求编辑：程序博客网时间：2024/06/07 02:33

--导出用户
exp system/oracle owner=sjck log=sjck_exp.log direct=y recordlength=65535 compress=n
expdp system/oracle dumpfile=sjck%U.dmp logfile=sjck_exp.log schemas=sjck parallel=4 compression=all

--导出表
exp system/oracle file=wd_nsr.dmp log=wd_nsr_exp.log tables=sjck.wd_nsr direct=y recordlength=65535 compress=n
expdp system/oracle dumpfile=wd_nsr%U.dmp logfile=wd_nsr_exp.log tables=sjck.wd_nsr parallel=4 compression=all

--导入用户（导入用户需提前存在）
imp system/oracle log=sjck_imp.log buffer=10000000 fromuser=sjck touser=sjck_copy
impdp system/oracle dumpfile=sjck%U.dmp logfile=sjck_imp.log schemas=sjck parallel=4

--导入表
imp system/oracle file=wd_nsr.dmp log=wd_nsr_imp.log tables=wd_nsr buffer=10000000 fromuser=sjck touser=sjck_copy
impdp system/oracle dumpfile=wd_nsr%U.dmp logfile=wd_nsr_imp.log tables=test.wd_nsr parallel=4

阅读全文

0 0