As you know, We use the export utility for many cases. I faced with that error on 11.2.0.2 DB on AIX 6.1 system.

During export 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 also there are some addition error messages are raised:
EXP-00006: internal inconsistency error
EXP-00000: Export terminated unsuccessfully

Complete error is:

. . exporting table XX
. . exporting table XX
. . exporting table XX
. . exporting table XX
. about to export X’s tables via Direct Path …
. about to export X’s tables via Direct Path …
. about to export X’s tables via Direct Path …
. about to export X’s tables via Direct Path …
. about to export X’s tables via Direct Path …
. about to export X’s tables via Direct Path …
. about to export X’s tables via Direct Path …
EXP-00113: Feature New Composite Partitioning Method is unsupported. Table X could not be exported
. . exporting table XX
. . exporting table XX
. . exporting table XX
. . exporting table XX
. . exporting table XX
. . exporting table XX
. . exporting table XX
. . exporting table XX
. . exporting table XX
. . exporting table XX
EXP-00006: internal inconsistency error
EXP-00000: Export terminated unsuccessfully

After making a search at Metalink, I noticed that; I met one bug.

The Bug  number is 7834212

From MOS note:
Bug 7834212 has been filed regarding this problem. However, it should be noted that the new composite partitioning and system partitioning is an 11g feature.

Classic Export does not support this. When a table with this feature is exported, an error message EXP-113 is raised.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.

So what is the solution? Here is the answer:

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

Reference:
Exporting System or Composite Partitioned Table Using Classic Export Gives EXP-6 AND EXP-0 (Doc ID 762774.1)

Advertisements