解决Oracle10g IMP-00058: 遇到 ORACLE 错误 4063

使用oracle数据库导入imp命令时报错：

IMP-00058: 遇到 ORACLE 错误 4063
ORA-04063: package body “SYS.DBMS_EXPORT_EXTENSION” has errors
ORA-06508: PL/SQL: could not find program unit being called: “SYS.DBMS_EXPORT_EXTENSION”
ORA-06512: at line 1
IMP-00000: 未成功终止导入

---

解决办法:
连接数据库：sqlplus system/sys as sysdba

编译：ALTER PACKAGE DBMS_EXPORT_EXTENSION COMPILE BODY;

查询：
select owner,object_name,object_type,status from dba_objects
where object_name = ‘DBMS_EXPORT_EXTENSION’;

又遇到DBMS_STATS的错误
继续编译：ALTER PACKAGE DBMS_STATS COMPILE BODY;
查询：select owner,object_name,object_type,status from db