Invalid DBMS_CUBE_EXP (Doc ID 2017988.1)

Last updated on JUNE 13, 2017

Applies to:

Oracle OLAP - Version 11.2.0.3 and later
Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.

Symptoms

An 11G  DataPump export fails with the following errors:

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS []
ORA-31642: the following SQL statement fails:
BEGIN "SYS"."DBMS_CUBE_EXP".SCHEMA_CALLOUT(:1,0,1,'11.02.00.00.00'); END;
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_METADATA", line 1749
ORA-04063: package body "SYS.DBMS_CUBE_EXP" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_CUBE_EXP"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 8996
----- PL/SQL Call Stack -----
  object line object
  handle number name
700002d5bf94c08 20462 package body SYS.KUPW$WORKER
700002d5bf94c08 9028 package body SYS.KUPW$WORKER
700002d5bf94c08 10935 package body SYS.KUPW$WORKER
700002d5bf94c08 13698 package body SYS.KUPW$WORKER
700002d5bf94c08 2654 package body SYS.KUPW$WORKER
700002d5bf94c08 9697 package body SYS.KUPW$WORKER
700002d5bf94c08 1775 package body SYS.KUPW$WORKER
700002d7ea7d830 2 anonymous block

 

SQL> alter package DBMS_CUBE_EXP compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors
Errors for PACKAGE BODY DBMS_CUBE_EXP:

LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0      PLS-00753: malformed or corrupted wrapped unit

 

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