11.2.0.1 exp-00006 exp-00000 bug

jiawang

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

SymptomsWhen 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
Bug 7834212 has been filed regarding this problem. 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.
But if the table partition has split or added a new partition, it will now generate the EXP-6 and EXP-0 errors and fail to complete.


NOTE:
Original Export is desupported for general use as of Oracle Database 11g. The only supported use of original Export in Oracle Database 11g is backward migration of XMLType data to Oracle Database 10g release 2 (10.2) or earlier. Therefore, Oracle recommends that you use the new Data Pump Export and Import utilities
Please refer to:
http://docs.oracle.com/cd/E11882 ... xport.htm#SUTIL3634


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