问题现象:
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.
Solution
As per compatibility Matrix,You need to use the export utility of the lower version of source and target database.
-- The End --
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/519536/viewspace-468231/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/519536/viewspace-468231/