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
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.
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
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.
Use DataPump to perform exports of composite partitioning and system partitioned tables as this is the recommended method.
BUG:7834212 - EXPORT FAILS WITH EXP-6 AND EXP-0 ON PARTITIONED TABLE INSTEAD OF EXP-113
------------------------------------------------------------------------------
QQ: 492913789
Email:ahdba@qq.com
Blog: http://www.cndba.cn/dave
DBA1 群：62697716(满); DBA2 群：62697977(满)
DBA3 群：62697850 DBA 超级群：63306533;
聊天 群：40132017
--加群需要在备注说明Oracle表空间和数据文件的关系，否则拒绝申请
