Impdp error ORA-39083, ORA-04067, ORA-06508

Oct 25, 2018 5:07AM

hello,

I execute an impdp of schema from my database in version 12.1.0.2

then I have this next error :

ORA-39083: Object type INDEX:"WT9PRD01"."PROJECTPLAN$COMPOSITE1" failed to create with error:

ORA-04067: not executed, package body "WT9PRD01.WTPREFIXPK" does not exist

ORA-06508: PL/SQL: could not find program unit being called: "WT9PRD01.WTPREFIXPK"

Failing sql is:

CREATE INDEX "WT9PRD01"."PROJECTPLAN$COMPOSITE1" ON "WT9PRD01"."PROJECTPLAN" (UPPER("WT9PRD01"."WTPREFIXPK"."PREFIX"("NAME")))

>>>>>>

I understand that : when Impdp of Oracle execute a create index and the procedure "WTPREFIXPK" is not still created.

How is it possible to tell to Impdp execute the procedure "WTPREFIXPK" before "Create Indexe" ?

Database Utilities (MOSC)