http://resources.arcgis.com/zh-cn/content/kbase?fa=articleShow&d=38470
ArcSDE版本:9.3.1和10
在Oracle11.2.0.1数据库使用数据泵(EXPDP、IMPDP)进行数据导入导出,在导入(IMPDP)过程中在导入日志文件报
"ORA-39083: Object type INDEX failed to create with error:
ORA-14102: only one LOGGING or NOLOGGING clause may be specified
主要是执行下面的SQL语句出错
CREATE UNIQUE INDEX <schema>.<Index name> ON <schema>.<table name> (<columns>) PCTFREE 10 INITRANS 2 MAXTRANS 255 NOLOGGING NOCOMPRESS LOGGING STORAGE( INITIAL 393216 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "<TS Name>" PARALLEL 1"
如果索引为压缩索引,那么在导入日志文件报如下错误:
"ORA-39083: Object type INDEX failed to create with error:
ORA-02158: invalid CREATE INDEX option
Failing sql is:
CREATE UNIQUE INDEX <schema>.<Index name> ON <schema>.<table name> (<columns>)
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "<TS Name>"
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
ORA-39112: Dependent object type INDEX_STATISTICS skipped, base object type <schema>.<Index name> creation failed"
这是Oracle11.2.0.1的问题
下载Oracle的8795792补丁即可,补丁下载地址:https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=PROBLEM&id=1066635.1
作者在Oracle11.1.0.6环境下进行数据泵的实验没有碰到类似问题