This discussion is archived
6 Replies Latest reply: Nov 5, 2012 4:24 AM by 968655 RSS

Export failed with error ORA-04063: package body "SYS.DBMS_CUBE_EXP" has er

968655 Newbie
Currently Being Moderated
Hi

We are having 11.2.0.2 database on Linux 5. From last two days the export backup is getting failed with the below error.

. exporting post-schema procedural objects and actions
EXP-00008: ORACLE error 4063 encountered
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 line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_CUBE_EXP.schema_i
. exporting statistics
Export terminated successfully with warnings.

When I checked the status of this package DBMS_CUBE_EXP its showing invalid. I tried to compile the body of the package. But it was throwing below error.

SQL> show errors
Errors for PACKAGE BODY DBMS_CUBE_EXP:

LINE/COL ERROR
-------- ----------------------------------------------------------------
53/5 PL/SQL: SQL Statement ignored
54/10 PL/SQL: ORA-04045: errors during recompilation/revalidation of
SYS.DBA_XDS_INSTANCE_SETS
ORA-01422: exact fetch returns more than requested number of rows

I tried to query this view or describe the above view. But it was throwing the same error.

ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of
SYS.DBA_XDS_INSTANCE_SETS
ORA-01422: exact fetch returns more than requested number of rows

I couldnt get a proper solution from google regarding this view or to compile the above package.

Now we are stcuked without the backups. It would be great if you guys look into it.

Thanks
SHIYAS M
  • 1. Re: Export failed with error ORA-04063: package body "SYS.DBMS_CUBE_EXP" has er
    Sunny kichloo Expert
    Currently Being Moderated
    Are you using SYS User for taking export Backup
  • 2. Re: Export failed with error ORA-04063: package body "SYS.DBMS_CUBE_EXP" has er
    968655 Newbie
    Currently Being Moderated
    Yes I tried with take the export with SYS user. This time it thrown the error in the first and last too same as before.

    About to export specified users ...
    . exporting pre-schema procedural objects and actions
    EXP-00008: ORACLE error 4063 encountered
    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 line 1
    EXP-00083: The previous problem occurred when calling SYS.DBMS_CUBE_EXP.schema_info_exp
    . exporting foreign function library names for user U_20102
    . exporting PUBLIC type synonyms
    . exporting private type synonyms
    . exporting object type definitions for user U_20102
    About to export U_20102's objects ...


    I ran below scripts as per u provided the link

    @$ORACLE_HOME/rdbms/admin/catdpb.sql and utlrp.sql

    Still it didnt get compiled.

    One more thing I tried running expdp. It totally got failed by throwing the similar error. It didnt even export the tables too.

    ===============================================================================

    Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
    ORA-39126: Worker unexpected fatal error in KUPW$WORKER.GET_TABLE_DATA_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 1245
    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 8353

    ----- PL/SQL Call Stack -----
    object line object
    handle number name
    0x1a3257060 19208 package body SYS.KUPW$WORKER
    0x1a3257060 8385 package body SYS.KUPW$WORKER
    0x1a3257060 12748 package body SYS.KUPW$WORKER
    0x1a3257060 2546 package body SYS.KUPW$WORKER
    0x1a3257060 9054 package body SYS.KUPW$WORKER
    0x1a3257060 1688 package body SYS.KUPW$WORKER
    0x1a8bc1630 2 anonymous block

    Estimate in progress using BLOCKS method...
    Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
    ORA-39126: Worker unexpected fatal error in KUPW$WORKER.GET_TABLE_DATA_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 1245
    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 8353

    ----- PL/SQL Call Stack -----
    object line object
    handle number name
    0x1a3257060 19208 package body SYS.KUPW$WORKER
    0x1a3257060 8385 package body SYS.KUPW$WORKER
    0x1a3257060 12748 package body SYS.KUPW$WORKER
    0x1a3257060 2546 package body SYS.KUPW$WORKER
    0x1a3257060 9054 package body SYS.KUPW$WORKER
    0x1a3257060 1688 package body SYS.KUPW$WORKER
    0x1a8bc1630 2 anonymous block

    Job "SYS"."SYS_EXPORT_SCHEMA_01" stopped due to fatal error at 17:58:34

    =========================================================================
  • 3. Re: Export failed with error ORA-04063: package body "SYS.DBMS_CUBE_EXP" has er
    Helios-GunesEROL Oracle ACE
    Currently Being Moderated
    Hi;

    Similar error mention at      Ora-39127: Unexpected Error From Call To Export_string :=Sys.Dbms_cube_exp [ID 811934.1]. Please review

    Regard
    Helios
  • 4. Re: Export failed with error ORA-04063: package body "SYS.DBMS_CUBE_EXP" has er
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    also check
    Full Database Export Fails With Errors ORA-1031 EXP-83 On Resource Manager Objects [ID 105955.1]
  • 5. Re: Export failed with error ORA-04063: package body "SYS.DBMS_CUBE_EXP" has er
    968655 Newbie
    Currently Being Moderated
    The link provided has helped me. It was due to workspace package from export. DBMS_CUBE_EXP was deleted from the workspace. After that export is working fine.

    Thanks a lot.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points