原文:http://jingh3209.blog.163.com/blog/static/156966720099223659814/
问题现象:
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完成数据的迁移。
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.0This problem can occur on any platform.
Symptoms
While trying to export 9.2.0.6 database with 10.2.0.1.0 Exp utilityreceive 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.