My Oracle Support Banner

Invalid DBMS_CUBE_EXP (Doc ID 2017988.1)

Last updated on APRIL 05, 2024

Applies to:

Oracle OLAP - Version 11.2.0.3 and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data from the Oracle sample or bulit-in schema(s), Public Documentation delivered with an Oracle database product or other training material.  Any similarity to actual environments, actual persons, living or dead, is purely coincidental and not intended in any manner.

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

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.