Exporting System or Composite Partitioned Table Using Classic Export Gives EXP-6 AND EXP-0

最新推荐文章于 2021-04-04 23:16:35 发布

最新推荐文章于 2021-04-04 23:16:35 发布 · 82 阅读

文章标签：

#数据库

当使用传统导出工具处理包含复合或系统分区的Oracle表时，可能会遇到EXP-6和EXP-0错误。此类错误通常发生在对分区进行拆分或新增操作后。推荐解决方案是采用数据泵进行导出。

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

	Modified20-DEC-2010TypePROBLEMStatusPUBLISHED

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 problemBug 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.