oracle impdp问题及解决方法 (2013-05-16 12:14:28)转载▼
分类: oracle
解决方法:
drop directory backup
mkdir /u01/app/oracle/flash_recovery_area/ORCL/backup
create directory backup as ‘/u01/app/oracle/flash_recovery_area/ORCL/backup’;
grant read,write on directory backup to scott
cp orcl2_scott_tables03.dmp /u01/app/oracle/flash_recovery_area/ORCL/backup
impdp scott/tiger directory=backup dumpfile=orcl2_scott_tables03.dmp
主要就是要expdp导出来的文件放到 select * from dba_directories;
这条sql能查出来的path里面,
之后再用impdp 导入就ok