暂无图片
impdp时莫名其妙的ORA-31693报错
我来答
分享
吴明
2022-03-08
impdp时莫名其妙的ORA-31693报错

在源库做完expdp全库导出后,在目的库进行impdp导入。然后有如下报错:

. . imported "COMM"."PRICE_LIST" 1.414 MB 11017 rows
. . imported "COMM"."SECURITY_INFO" 1.085 MB 12893 rows
. . imported "COMM"."SECURITY_TEMPLATE" 866.1 KB 6417 rows
ORA-31693: Table data object "LAB"."LAB_TEST_ITEMS" failed to load/unload and is being skipped due to error:
ORA-31640: unable to open dump file "/home/oracle/datapump/expdp_full_hisdb.2022-03-08.01.dmp" for read
ORA-19505: failed to identify file "/home/oracle/datapump/expdp_full_hisdb.2022-03-08.01.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
. . imported "CPR"."CUSTOM_REPOSITORY" 60.07 KB 1326 rows
ORA-31693: Table data object "MEDREC"."MEDICAL_COSTS" failed to load/unload and is being skipped due to error:
ORA-31640: unable to open dump file "/home/oracle/datapump/expdp_full_hisdb.2022-03-08.01.dmp" for read
ORA-19505: failed to identify file "/home/oracle/datapump/expdp_full_hisdb.2022-03-08.01.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3


明明已经导入了一些表的数据,为何还报错提示找不到dmp文件呢。虽然不停的有这个报错,但是导入还在继续,有数据导入

我来答
添加附件
收藏
分享
问题补充
1条回答
默认
最新
吾喾

导入时是不是加并行了,把并行去掉试试

暂无图片 评论
暂无图片 有用 0
暂无图片
吴明
题主
2022-03-08
哦 对对对
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏