imp PLS-00302: component 'SET_NO_OUTLINES' must be declared 问题的处理

最新推荐文章于 2021-04-03 16:01:59 发布

aicon

最新推荐文章于 2021-04-03 16:01:59 发布

阅读量1.2k

点赞数

CC 4.0 BY-SA版权

文章标签： oracle database matrix import server c

本文链接：https://blog.youkuaiyun.com/aicon/article/details/4585236

当尝试使用10.2.0.1版本的Export实用程序导出9.2.0.6数据库时，遇到PLS-00302错误。该问题出现在不同版本数据库之间使用高版本Export工具。解决方案是根据兼容性矩阵，使用源和目标数据库低版本的Export和Import工具。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Subject:PLS-00302-SET_NO_OUTLINES must be declared When Using 10.2 Export Utility

Doc ID:NOTE:339062.1

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1.0
This problem can occur on any platform.

Symptoms

While trying to export 9.2.0.6 database with 10.2.0.1.0 Exp utility
receive following errors:-

Export: Release 10.2.0.1.0 - Production on Tue Oct 25 17:11:46 2005
Copyright (c) 1982, 2005, Oracle. All rights reserved.
EXP-00056: ORACLE error 6550 encountered
ORA-06550: line 1, column 41:
PLS-00302: component 'SET_NO_OUTLINES' must be declared
ORA-06550: line 1, column 15:
PL/SQL: Statement ignored
EXP-00000: Export terminated unsuccessfully

Cause

Use of Higher Version Export utility (10.2.0.1) on Lower version database(9.2.0.6).

This problem occurs when using 10.2 Exp utility for 10.1,9.2,8.1.7 databases.

Solution

As per compatibility Matrix,You need to use the export utility of the lower version of source and target database.

错误信息：

IMP-00058: ORACLE error 6550 encountered
ORA-06550: line 1, column 33:
PLS-00302: component 'SET_NO_OUTLINES' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
IMP-00000: Import terminated unsuccessfully

产生原因：

使用10.2.0.1版本的exp导出的文件，但是目标端使用的是10.1.0.2版本的imp导入的，所以报错

解决方法：

使用低版本的exp和imp完成数据的迁移。

FROM:http://hi.baidu.com/icewee/blog/item/1d3fdc9451133043d1135e02.html