expdp:ORA-04063,ORA-06508

经过：

1. 环境：服务器：chndsora9，实例cdesb01，数据库版本11.2.0.4
2. 操作：导出用户schema ‘ESBST02所有表到‘ESBST03下
3. 执行命令：expdp \‘/ as sysdba \‘ directory=DATA_PUMP_DIR dumpfile= ESBST02_0336.DMP logfile=ESBST02200326.log schemas=ESBST02 compression=all;
4. 报错：>>> ORA-31642: the following SQL statement fails:

BEGIN "SYS"."DBMS_CUBE_EXP".SCHEMA_CALLOUT(:1,0,1,‘11.02.00.04.00‘); END;

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"

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 281 MB

Processing object type SCHEMA_EXPORT/USER

Processing object type SCHEMA_EXPORT/SYSTEM_GRANT

Processing object type SCHEMA_EXPORT/ROLE_GRANT

Processing object type SCHEMA_EXPORT/DEFAULT_ROLE

Processing object type SCHEMA_EXPORT/PASSWORD_HISTORY

ORA-39127: unexpected error from call to export_string :=SYS.DBMS_CUBE_EXP.SCHEMA_INFO_EXP(‘ESBST02‘,0,1,‘11.02.00.04.00‘,newblock)

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

ORA-06512: at "SYS.DBMS_METADATA", line 10256

Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE

ORA-39127: unexpected error from call to export_string :=SYS.DBMS_CUBE_EXP.INSTANCE_EXTENDED_INFO_EXP(‘AW$EXPRESS‘,‘SYS‘,1,2,0,‘SYS‘,1,‘11.02.00.04.00‘,newblock)

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"

1. 我的解决办法（还没有实施，本来想在MOS上面找的，但是MOS一直打不开），请大家帮忙分析下，有没有更好的办法，这个办法具有一定风险性：

Perform the following:
sqlplus / as sysdba

— backup the table SYS.EXPPKGACT$ before deleting the row
SQL> CREATE TABLE SYS.EXPPKGACT$_BACKUP AS SELECT * FROM SYS.EXPPKGACT$;

— delete the DBMS_CUBE_EXP from the SYS.EXPPKGACT$
SQL> DELETE FROM SYS.EXPPKGACT$ WHERE PACKAGE = ‘DBMS_CUBE_EXP’ AND SCHEMA= ‘SYS’;
SQL> COMMIT;

Run EXPDP command again.

expdp:ORA-04063,ORA-06508

原文：https://www.cnblogs.com/youzirourou/p/12598053.html