Article - CS73598
Errors importing Oracle dump "ORA-39083 ORA-04067 ORA-06508" when preparing for an upgrade to Windchill PDMLink
Modified: 30-May-2023
Applies To
- Windchill PDMLink 10.0 to 11.1
Description
- Import using data pump (impdp) with Oracle 11.2.0.3 returns:
-
ORA-39083: Object type INDEX failed to create with error: ORA-04067: not executed, package body "SCHEMA_NAME.WTPK" does not exist ORA-06508: PL/SQL: could not find program unit being called: "SCHEMA_NAME.WTPK" Failing sql is: CREATE INDEX "SCHEMA_NAME"."STRINGVALUE$COMPOSITE0" ON "SCHEMA_NAME"."STRINGVALUE" ("IDA3A4", "IDA3A6", "CLASSNAMEKEYA4", "SCHEMA_NAME"."WTPK"."PREFIX"("VALUE")) PCTFREE 10 INITRANS 2 MAXTRANS 140 STORAGE(INITIAL 106496 NEXT 106496 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS
-
- With other versions of Oracle, similar errors might be returned for the following package bodies:
- WTReversePK
- WTPrefixPK
- WipPk
- Where to find the sql scripts to resolve these errors?
- Fails to import dump with error:
-
ORA-04067: not executed, package body "SCHEMA_NAME.WipPk" does not exist
-
This is a printer-friendly version of Article 73598 and may be out of date. For the latest version click CS73598