【oracle】数据泵expdp与impdp

1、创建directory

create directory dump_dir as 'D:\dump_dir'

 

2、expdp备份schema

expdp  system/1qaz2wsx@ETCNC directory=dump_dir dumpfile=backupfile.dmp logfile=expdp_log.log schemas=LQEAM

 

3、impdp恢复指定schema，并改名

impdp system/1qaz2wsx@ETCNC  directory=dump_dir dumpfile=backupfile.dmp logfile=impdp_log.log rempap_schema=LQEAM:LQ

 

转载于:https://www.cnblogs.com/uzipi/p/5686460.html