Data Pump Import, IMPDP, Fails to Create Text Domain Indexes due to ORA-39083 Error

(Doc ID 1086439.1)

Last updated on JANUARY 07, 2016

Applies to:

Oracle Text - Version 10.2.0.1 to 11.1.0.7 [Release 10.2 to 11.1]
Information in this document applies to any platform.

Symptoms

While importing data with Data Pump Import it throws an error similar to below message, while creating local partitioned Text indexes:

Processing object type TABLE_EXPORT/TABLE/INDEX/DOMAIN_INDEX/INDEX
ORA-39083: Object type INDEX failed to create with error:
ORA-14024: number of partitions of LOCAL index must equal that of the underlying table
Failing sql is:
CREATE INDEX "HUGOTEXT"."XCTX_SEI_CTXALL" ON "HUGOTEXT"."XSEITE" ("CTXALL") INDEXTYPE IS "CTXSYS"."CONTEXT" FILTER BY "VEROEFF_TS", "IMP_MANDANT", "SPERRE_FLAG", "SEITE_ID" ORDER BY "VEROEFF_TS" DESC, "SEITE_ID" DESC PARAMETERS ('
DATASTORE XDATASTORE_SEI_CTXALL
LEXER HUGOTEXT_LEXER
WORDLIST HUGOTEXT_WORDLIST
SECTION GROUP XSECTI


Thus the Text domain index is not being imported.

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