首页 > 其他 > 详细

impdp 时遇到ORA-02368 file string is not valid for this load operation

时间:2021-08-06 12:10:12      阅读:48      评论:0      收藏:0      [点我收藏+]

impdp 时遇到ORA-02368 file string is not valid for this load operation

 

Datapump Import Fails To Start With Error ORA-02368 [ID 735625.1]

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.2
This problem can occur on any platform.

Symptoms

Getting the following error when starting datapump import:

ORA-31694: master table "RECOVERED"."SYS_IMPORT_FULL_01" failed to load/unload
ORA-02354: error in exporting/importing data
ORA-02368: file is not valid for this load operation

Cause

It could be due to dump file corruption.
(may be the file has been transfered by ftp, or processed by a compression utility which introduced corruption)

Solution

Re-run the export to get a fresh dump file, and try the import again.

 

在本次的impdp时,最终判断是此a.dmp文件从window2003拷下来时,遇到问题(windows2003提示系统系统资源不足,导致a.dmp文件虽然拷下来了,但是里边的内容已经是corruption了)。。。重新从win xp客户端,远程访问win2003 ,移动硬盘接在xp客户端上,不接在win2003上,这样重新拷一次即可。

impdp 时遇到ORA-02368 file string is not valid for this load operation

原文:https://www.cnblogs.com/gdjgs/p/15107475.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!