oracle exp出现ORA-06550

最新推荐文章于 2026-01-06 05:16:35 发布

转载最新推荐文章于 2026-01-06 05:16:35 发布 · 1.3k 阅读

标签

#数据库

本文记录了解决Oracle数据库导出时遇到的多种错误的过程，包括处理PLS-00201标识符未声明、ORA-06550及ORA-06510等错误的方法，并提供了解决方案。

今天在做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

以下查到的一些资料。

oracle 10.2G

在导出是出现：
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数据库导出。

资源２：

http://blog.chinaunix.net/u/2780/showart_971366.html

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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8102208/viewspace-629098/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8102208/viewspace-629098/