6 Replies Latest reply: Jan 17, 2013 4:43 AM by dba-india RSS

    expdp with ORA-04063: package body "SYS.DBMS_CUBE_EXP" error

    931308
      Hi,
      I try to use expdp to export all tables from schema BAW, but hit the following error. Oracle version is 11.2.0.2, and the package body "SYS.DBMS_CUBE_EXP" is invalid. Any idea to fix it?


      Starting "BAW"."SYS_EXPORT_SCHEMA_01": baw/******** directory=DATA_PUMP_DIR met
      rics=yes schemas=baw dumpfile=baw.dmp
      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.02.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
      7000004c9656fe0 19208 package body SYS.KUPW$WORKER
      7000004c9656fe0 8385 package body SYS.KUPW$WORKER
      7000004c9656fe0 12748 package body SYS.KUPW$WORKER
      7000004c9656fe0 2546 package body SYS.KUPW$WORKER
      7000004c9656fe0 9054 package body SYS.KUPW$WORKER
      7000004c9656fe0 1688 package body SYS.KUPW$WORKER
      7000004c9659720 2 anonymous block
      object line object
      handle number name
      7000004c9656fe0 19208 package body SYS.KUPW$WORKER
      7000004c9656fe0 8385 package body SYS.KUPW$WORKER
      7000004c9656fe0 12748 package body SYS.KUPW$WORKER
      7000004c9656fe0 2546 package body SYS.KUPW$WORKER
      7000004c9656fe0 9054 package body SYS.KUPW$WORKER
      7000004c9656fe0 1688 package body SYS.KUPW$WORKER
      7000004c9659720 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.02.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
      7000004c9656fe0 19208 package body SYS.KUPW$WORKER
      7000004c9656fe0 8385 package body SYS.KUPW$WORKER
      7000004c9656fe0 12748 package body SYS.KUPW$WORKER
      7000004c9656fe0 2546 package body SYS.KUPW$WORKER
      7000004c9656fe0 9054 package body SYS.KUPW$WORKER
      7000004c9656fe0 1688 package body SYS.KUPW$WORKER
      7000004c9659720 2 anonymous block
      Job "BAW"."SYS_EXPORT_SCHEMA_01" stopped due to fatal error at 16:07:26
      e