ORA-39245处理

本日接到保障在11g通过数据泵导入数据时报错，ORA-39245，查询文档发现说明如下

[oracle@evenpc ~]$ oerr ora 39245
39245, 00000, "import job requires export dump file \"%s\""
// *Cause:    A Data Pump IMPORT or SQL_FILE operation was being performed 
//            but not all of the files from the Data Pump export dump file 
//            set were included.
// *Action:   Check the export log file and make sure all of the files that
//            were exported are included in the current job. The import log
//            file also lists the export names of the missing files.

用户说导出给了一个文件，导入的时候死活导入不了。

检查用户导出操作命令如下：

expdp user/passwd  directory=dump_dir dumpfile=test%U.dmp parallel=2 logfile=test.log schemas

发现用户用了parallel参数，导出的时候绝对不止生成一个文件，问题找到了，用户导入的时候只导入了一个文件，就会报错了。

修改下导入操作命令如下

impdp user/passwd directory=dump_dir dumpfile=test01.dmp,test02.dmp parallel=2 schemas=test logfile=test_imp.log

问题解决。