Oracle-exp不支持自扩展分区表的导出EXP-00006,EXP-00000

一、Oracle-exp不支持自扩展分区表的导出

有同事沟通说exp导出自扩展的分区表报错，测试了一下果然如此哈。

 CREATE TABLE "T_PART_TABLE"
   (    "ID" VARCHAR2(64),
    "PERSOID" NUMBER,
    "CODE" VARCHAR2(64),
    "NAME" VARCHAR2(64),
    "DEPT" VARCHAR2(64),
    "LOG_TIME" NUMBER,
    "LOG_TYPE" NUMBER,
    "CONTENT" VARCHAR2(1024),
    "RESULT" VARCHAR2(2),
    "SN" VARCHAR2(128),
    "DEPT_ID" NUMBER,
    "BLACK_FLAG" VARCHAR2(2 BYTE),
    "CREATE_TIME" Date)
    PARTITION BY RANGE (CREATE_TIME)  interval (numtodsinterval (1,'DAY'))
(
 PARTITION part_p180613 VALUES LESS THAN (TO_DATE('2018-6-13', 'yyyy-mm-dd'))
 );
insert into T_PART_TABLE(ID,CREATE_TIME) values(1,sysdate);
insert into T_PART_TABLE(ID,CREATE_TIME) values(2,sysdate+1);
commit;

[oracle@t2 ~]$ exp yz/yz file=/home/oracle/T_PART_TABLE.dmp tables=T_PART_TABLE
Export: Release 11.2.0.4.0 - Production on Tue Oct 19 13:28:37 2021
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in AL32UTF8 character set and AL16UTF16 NCHAR character set
About to export specified tables via Conventional Path ...
EXP-00006: internal inconsistency error
EXP-00000: Export terminated unsuccessfully

 

二、学习MOS

Exporting System or Composite Partitioned Table Using Classic Export Gives EXP-6 AND EXP-0 (Doc ID 762774.1)    
Oracle Cloud Infrastructure - Database Service - Version N/A and later
When exporting a composite. interval, 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 <TABLE_NAME> 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.
SOLUTION
Use Data Pump to perform exports of composite and interval 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

小结： Oracle的意思就是说Oracle 11g有复合分区和自扩展分区的新特性，但是呢，这些新的特性Oracle exp不在支持了，所以报错！ Oracle建议使用expdp而非exp!!!