ORA-39083 Functional Indexes Excluded on Datapump Import
Last updated on NOVEMBER 28, 2016
Applies to:Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Information in this document applies to any platform.
***Checked for relevance on 23-Nov-2016***
When running a Datapump Import you receive the following errors:
ORA-00904: "MD7_T24ADMIN"."NUMCAST": invalid identifier
Failing sql is:
CREATE INDEX "RBC_T24ADMIN"."NIX_EBF_HOLD_CO000_C8" ON "RBC_T24ADMIN".
"NUMCAST"(EXTRACTVALUE(SYS_MAKEXML("SYS_NC00003$"),'/row/c8')),0)) PCTFREE 10
INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 2097152 NEXT 1048576 MINEXTENTS 1
MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL
DEFAULT) TABLESPACE "RBC_T24DATA" PARALLEL
The above error was generated when trying to use Datapump to import into a new schema from a datapump export containing 2 schemas.
Function-based indexes are being excluded during the import as per the above errors.
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