exp 报错 PLS-00302-SET_NO_OUTLINES

最新推荐文章于 2021-04-06 15:45:46 发布

原创最新推荐文章于 2021-04-06 15:45:46 发布 · 253 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库

数据库专栏收录该内容

27 篇文章

订阅专栏

文章详细介绍了在使用高版本Oracle客户端导出低版本数据库时遇到的错误，即PLS-00302：组件'SET_NO_OUTLINES'必须声明。文章指出这是由于使用了高版本的导出工具与低版本数据库不兼容导致的问题，并提供了解决方案：使用与源和目标数据库版本相匹配的导出工具。

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.

高版本的客户端导出低版本的数据库，回报错，建议安装低版本的oracle的客户端