oracle impdp导入数据报ora-29913、ora-31640

环境：aix6.1、oracleRAC11.2.4

impdp导入报

ORA-29913: 执行 ODCIEXTTABLEPOPULATE 调出时出错

impdp XSFX/XSFX DIRECTORY=DIR_IMPDP DUMPFILE=tb_uu%U.dmp PARALLEL=5 REMAP_SCHEMA=EIC_XSJS:XSF X remap_tablespace=TSP_XSJS:USERS Import: Release 11.2.0.1.0 - Production on 星期二 7月 10 10:21:13 2018 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. 连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options 已成功加载/卸载了主表 "XSFX"."SYS_IMPORT_FULL_01" 启动 "XSFX"."SYS_IMPORT_FULL_01": XSFX/******** DIRECTORY=DIR_IMPDP DUMPFILE=tb_uu%U.dmp PARALLEL=5 REMAP_SCHEMA=EIC_XS JS:XSFX remap_tablespace=TSP_XSJS:USERS 处理对象类型 TABLE_EXPORT/TABLE/TABLE 处理对象类型 TABLE_EXPORT/TABLE/TABLE_DATA ORA-31693: table data object "DZXT5119","DZGL_ZXJD_SLXXB" failed to load/unload and is beng skipped due to error:

ORA-29913:error in executing ODCIEXTTABLEOPEN callout

ORA-31640:unable to open dump file "/data_pic/dzxt_data_5119_01.dmp" for read

ORA-19505:failed to identify file "/data_pic/dzxt_data_5119_01.dmp"

ORA-27037:unable to obtain file status

IBM AIX System/600 Error:2:Nosuch file or directory

 

可能原因：

1、有用户占用表，清理锁表，或者直接重启oracle shutdown immediate ，startup

2、导出的dump文件没有权限，配置权限。chown 775 *.dmp

3、并行导入的原因，将并行设置为1 .PARALLEL=1