Loading

【oracle】数据泵expdp与impdp

1、创建directory

create directory dump_dir as 'D:\dump_dir'

 

2、expdp备份schema

expdp  system/YourPassword@HostName directory=dump_dir dumpfile=backupfile.dmp logfile=expdp_log.log schemas=SchemaName

 

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

impdp system/YourPassword@HostName  directory=dump_dir dumpfile=backupfile.dmp logfile=impdp_log.log rempap_schema=SchemaName:Test

 

posted @ 2016-07-19 22:15  uzipi  阅读(428)  评论(0编辑  收藏  举报