ArcSDE版本:9.3.1和10
在Oracle11.2.0.1数据库使用数据泵(EXPDP、IMPDP)进行数据导入导出,在导入(IMPDP)过程中在导入日志文件报
1. “ORA-39083: Object type INDEX failed to create with error:
2.
3. ORA-14102: only one LOGGING or NOLOGGING clause may be specified
主要是执行下面的SQL语句出错
1. CREATE UNIQUE INDEX . ON .
如果索引为压缩索引,那么在导入日志文件报如下错误:
1. “ORA-39083: Object type INDEX failed to create with error:
2.
3. ORA-02158: invalid CREATE INDEX option
4. Failing sql is:
5.
6. CREATE UNIQUE INDEX . ON .
7. PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE “”
8.
9. Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
10.
11. ORA-39112: Dependent object type INDEX_STATISTICS skipped, base object type . creation failed”
这是Oracle11.2.0.1的问题