Datapump import fails on create index
My datapump import into 11gR2 database (export from 10gR2 database) fails with the following error:
ORA-39083: Object type INDEX failed to create with error:
ORA-02158: invalid CREATE INDEX option
Failing sql is:
CREATE INDEX "MY_SCHEMA"."MY_INDEX_NAME" ON "MY_SCHEMA"."MY_TABLE" ("COLUMN_NAME") PCTFREE 10 INITRANS 2 MAXTRANS 255 NOLOGGING STORAGE(INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "MY_TABLESPACE_S_I" PARALLEL 2 DEFAULT) TABLESPACE "MY_OTHER_TABLESPACE_M_I" PARALLEL 4
I've seen some errors concerning invalid syntax when exporting compressed indexes. This index isn't compressed. Note that in de create statement 2 different tablespace-names are mentioned, the statement is incorrect because there's one ) too many... And two different tablespace names.