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