oracle pls 00905,exp报错 ORA-06550 PLS-00905（未解决）

exp报错，

. exporting triggers

EXP-00056: ORACLE error 6550 encountered

ORA-06550: line 1, column 30:

PLS-00905: object XDB.DBMS_XDBUTIL_INT is invalid

ORA-06550: line 1, column 14:

PL/SQL: Statement ignored

EXP-00056: ORACLE error 6550 encountered

ORA-06550: line 1, column 30:

PLS-00905: object XDB.DBMS_XDBUTIL_INT is invalid

ORA-06550: line 1, column 14:

PL/SQL: Statement ignored

EXP-00000: Export terminated unsuccessfully

根据网上的资料，尝试步骤：

把ora文件中

#dispatchers="(PROTOCOL=TCP) (SERVICE=epvnmsXDB)"

注释掉，重启oracle，备份，故障依旧。

查询一下是否有DBMS_XDBUTIL_INT

SELECT status, object_id, object_type,

SUBSTR (owner || '.' || object_name, 1, 40) "OWNER.OBJECT"

FROM dba_objects

WHERE object_name = 'DBMS_XDBUTIL_INT';

STATUS   OBJECT_ID OBJECT_TYPE         OWNER.OBJECT

------- ---------- ------------------- --------------------------------------------------------------------------------

INVALID      43245 SYNONYM             PUBLIC.DBMS_XDBUTIL_INT

INVALID      43226 PACKAGE             XDB.DBMS_XDBUTIL_INT

INVALID      43243 PACKAGE BODY        XDB.DBMS_XDBUTIL_INT

2.最近做过升级吗，如果做过的话，验证各个组件是否都已经升级成功：

SELECT   SUBSTR (comp_id, 1, 15) comp_id, status,

SUBSTR (VERSION, 1, 10) VERSION, SUBSTR (comp_name, 1, 30) comp_name

FROM dba_registry

ORDER BY 1;

COMP_ID                        STATUS      VERSION              COMP_NAME

------------------------------ ----------- -------------------- ------------------------------------------------------------

AMD                            VALID       10.1.0.2.0           OLAP Catalog

APS                            VALID       10.1.0.2.0           OLAP Analytic Workspace

CATALOG                        VALID       10.1.0.2.0           Oracle Database Catalog Views

CATJAVA                        VALID       10.1.0.2.0           Oracle Database Java Packages

CATPROC                        INVALID     10.1.0.2.0           Oracle Database Packages and T

CONTEXT                        VALID       10.1.0.2.0           Oracle Text

EM                             VALID       10.1.0.2.0           Oracle Enterprise Manager

EXF                            VALID       10.1.0.2.0           Oracle Expression Filter

JAVAVM                         VALID       10.1.0.2.0           JServer JAVA Virtual Machine

ODM                            VALID       10.1.0.2.0           Oracle Data Mining

ORDIM                          VALID       10.1.0.2.0           Oracle interMedia

OWM                            VALID       10.1.0.2.0           Oracle Workspace Manager

SDO                            VALID       10.1.0.2.0           Spatial

XDB                            VALID       10.1.0.2.0           Oracle XML Database

XML                            VALID       10.1.0.2.0           Oracle XDK

XOQ                            VALID       10.1.0.2.0           Oracle OLAP API

重新编译

/u01/app/oracle/product/oracle10g/rdbms/admin/utlrp.sql

再备份，还是出错

单独编译

SQL> alter package xdb.dbms_xdbutil_int compile body;

警告: 更改的包体带有编译错误。

SQL> show errors

PACKAGE BODY XDB.DBMS_XDBUTIL_INT 出现错误:

LINE/COL ERROR

-------- -----------------------------------------------------------------

0/0      PL/SQL: Compilation unit analysis terminated

1/18     PLS-00304: 如果没有说明, 则无法编译 'DBMS_XDBUTIL_INT' 主体

1/18     PLS-00905: 对象 XDB.DBMS_XDBUTIL_INT 无效

搜了半天，重新编译，先编译package，竟然通过了，oh，mygod，

SQL> alter package    XDB.DBMS_XDBUTIL_INT compile package;

程序包已变更。

SQL> alter package XDB.DBMS_XDBUTIL_INT compile body;

程序包体已变更。

备份一切正常，但是又有其他报错

EXP-00008: ORACLE error 1455 encountered

ORA-01455: converting column overflows integer datatype

网上说是bug