ITPub博客

首页 > Linux操作系统 > Linux操作系统 > EXP-00006: internal inconsistency error

EXP-00006: internal inconsistency error

原创 Linux操作系统 作者:听海★蓝心梦 时间:2013-10-18 10:51:04 0 删除 编辑
今天在对一个oracle 11.2的数据库做exp导出的时候报错:
说明:开始用的分区表是11g的Interval 分区表,结果用exp导,报:

EXP-00006: internal inconsistency error
EXP-00000: Export terminated unsuccessfully

最后查ORACLE文档,发现是个BUG:

Exporting System or Composite Partitioned Table Using Classic Export Gives EXP-6 AND EXP-0 [ID 762774.1]



Modified 20-DEC-2010     Type PROBLEM     Status PUBLISHED

In this Document
  Symptoms
  Cause
  Solution
  References



Applies to:


Oracle Server - Enterprise Edition - Version: 11.1.0.7 to 11.2.0.1 - Release: 11.1 to 11.2
Information in this document applies to any platform.

Symptoms


When exporting a composite or system partitioned table using conventional export utility, it fails with EXP-6 and EXP-0 errors.

EXP-00006: internal inconsistency error
EXP-00000: Export terminated unsuccessfully

Cause


A bug has been filed regarding this problem Bug 7834212

However, it should be noted that the new composite partitioning and system partitioning is a 11g feature.
Classic Export does not support this. When a table with this feature is exported, an error message EXP-113 is raised

EXP-00113: Feature New Composite Partitioning Method is unsupported. Table MYTABLE could not be exported


But the export would still complete.

And in normal circumstances this error should continue to be seen, however, if the table partition has split or added a new partition, it will generate the EXP-6 and EXP-0 errors and fail to complete.

Solution


Use DataPump to perform. exports of composite partitioning and system partitioned tables as this is the recommended method.

References


BUG:7834212 - EXPORT FAILS WITH EXP-6 AND EXP-0 ON PARTITIONED TABLE INSTEAD OF EXP-113

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/751371/viewspace-774591/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-02-18

  • 博文量
    256
  • 访问量
    1201744