oracle exp出现ORA-06550
今天在做EXP导出时，遇到这个问题。
记录一下。
从9206的客户端导出10204的数据库。
exporting cluster definitions
. about to export SYSTEM's tables via Conventional Path ...
. . exporting table DEF$_AQCALL
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 18:
PLS-00201: identifier 'SYS.DBMS_DEFER_IMPORT_INTERNAL' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
ORA-06512: at "SYS.DBMS_SYS_SQL", line 1204
ORA-06512: at "SYS.DBMS_SQL", line 323
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 97
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 126
ORA-06512: at line 1
. . exporting table DEF$_AQERROR
EXP-00008: ORACLE error 6510 encountered
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 50
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 126
ORA-06512: at line 1
. . exporting table DEF$_CALLDEST
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 18:
PLS-00201: identifier 'SYS.DBMS_DEFER_IMPORT_INTERNAL' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
ORA-06512: at "SYS.DBMS_SYS_SQL", line 1204
ORA-06512: at "SYS.DBMS_SQL", line 323
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 97
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 126
ORA-06512: at line 1
. . exporting table DEF$_DEFAULTDEST
EXP-00008: ORACLE error 6510 encountered
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 50
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 126
ORA-06512: at line 1
. . exporting table DEF$_DESTINATION
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 18:
PLS-00201: identifier 'SYS.DBMS_DEFER_IMPORT_INTERNAL' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
ORA-06512: at "SYS.DBMS_SYS_SQL", line 1204
ORA-06512: at "SYS.DBMS_SQL", line 323
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 97
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 126
ORA-06512: at line 1
. . exporting table DEF$_ERROR
EXP-00008: ORACLE error 6510 encountered
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 50
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 126
ORA-06512: at line 1
. . exporting table DEF$_LOB 0 rows exported
. . exporting table DEF$_ORIGIN 0 rows exported
. . exporting table DEF$_PROPAGATOR 0 rows exported
以下查到的一些资料。
在导出是出现：
exp: Release 10.2.0.1.0 - Production on 星期四 11月 1 06:29:31 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
IMP-00058: 遇到 ORACLE 错误 6550
ORA-06550: 第 1 行, 第 33 列:
PLS-00302: 必须说明 'SET_NO_OUTLINES' 组件
ORA-06550: 第 1 行, 第 7 列:
PL/SQL: Statement ignored
IMP-00000: 未成功终止导入
原因：
客户端版本的问题
到服务器上导出，没有问题
我在客户端遇到同样问题，但到服务器上导解决了。
不能从高版本向低版本的oracle数据库导出。
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
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;
------------------------------ ----------- -------------------- ------------------------------------------------------------
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
PACKAGE BODY XDB.DBMS_XDBUTIL_INT 出现错误:
-------- -----------------------------------------------------------------
0/0 PL/SQL: Compilation unit analysis terminated
1/18 PLS-00304: 如果没有说明, 则无法编译 'DBMS_XDBUTIL_INT' 主体
1/18 PLS-00905: 对象 XDB.DBMS_XDBUTIL_INT 无效
ORA-01455: converting column overflows integer datatype
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/8102208/viewspace-629098/ ，如需转载，请注明出处，否则将追究法律责任。
