DataPump Import (IMPDP) Raises Errors ORA-39083 ORA-02158 ORA-39112 When Importing Compressed Indexes (Doc ID 989232.1)

Last updated on NOVEMBER 28, 2012

Applies to:

Oracle Server - Enterprise Edition - Version 11.2.0.1.0 to 11.2.0.1.0 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 28-NOV-2012***

Symptoms

DataPump Import (impdp) reports the following errors:

Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "SYSTEM"."T" 0 KB 0 rows
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
ORA-39083: Object type INDEX failed to create with error:
ORA-02158: invalid CREATE INDEX option
Failing sql is:
CREATE INDEX "SYSTEM"."I" ON "SYSTEM"."T" ("C1", "C2") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 NOCOMPRESS NOLOGGING TABLESPACE "USERS" PARALLEL 1
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
ORA-39112: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:"SYSTEM"."I" creation failed

Changes

The database was migrated to Oracle 11g Release 2.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms