Oracle数据库还原方法

 1 Win +X → 运行→cmd  
 2 
 3 C:\Documents and Settings\Administrator>sqlplus /nolog
 4 
 5 SQL> connect sys/password as sysdba
 6  
 7 已连接
 8  
 9 SQL>create directory db_bak as 'd:\ex';
10  
11 目录已创建
12 
13 SQL>grant read,write on directory db_bak to public;
14  
15 授权成功 //注意导入完成删除这个目录，命令 SQL>drop directory db_bak;
16 
17  SQL>select * from dba_directories; //查询还原目录是否建立成功
18 
19  -----------------导入语法：新建DOS窗口执行----------------
20 //还原到指定用户
21 C:\Documents and Settings\Administrator>impdp system/password@database directory=db_bak schemas=databaseName dumpfile=EXPDFileName.dmp logfile=EXPDP.log
22 //还原到指定新用户
23 C:\Documents and Settings\Administrator>impdp system/password@database directory=db_bak remap_schema=oldName:newName dumpfile=EXPDFileName.dmp logfile=EXPDP.log
24  注意：如果你想还原成其他用户，那要将schemas=databaseName 替换成 remap_schema=旧用户名:新用户名 
25
View Code