大牛好,今天数据泵导数据时遇到个问题:
前提:我是从ORACLE11.2.0.4 导入ORACLE11.2.0.1版本,用EXPDP和IMPDP。
导出时没报错,导入时报了个索引的错误:
Failing sql is:
CREATE INDEX "CABLEEX"."IDX_CMALL_PRODUCT_VOL" ON "CABLEEX"."T_CMALL_PRODUCT" (UPPER("VOLTAGE")) PCTFREE 10 INITRANS 2 MAXTRANS 255 NOLOGGING NOCOMPRESS LOGGING TABLESPACE "TBS_CABLEEX" PARALLEL 1
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
ORA-39083: Object type CONSTRAINT failed to create with error:
ORA-14102: only one LOGGING or NOLOGGING clause may be specified
google查后都说的是ORACLE11.2.0.1的一个BUG。
但是我有点疑问的是:根据报错的创建索引SQL,有NOLOGGING和LOGGING这些,而原库的创建索引语句并没有:
select dbms_metadata.get_ddl('INDEX','IDX_CMALL_PRODUCT_VOL', 'CABLEEX') from dual ;
CREATE INDEX "CABLEEX"."IDX_CMALL_PRODUCT_VOL" ON "CABLEEX"."T_CMALL_PRODUCT" (UPPER("VOLTAGE"))
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
TABLESPACE "TBS_CABLEEX"
这是什么原因呢?