D:>exp system/system@lngxtjdt file=g.dmp log=g.log buffer=65535000 owner=gistar,tongyan,chuanshu,xianlu
Export: Release 10.2.0.3.0 – Production on 星期三 7月 1 15:32:21 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
EXP-00056: 遇到 ORACLE 错误 6550
ORA-06550: 第 1 行, 第 41 列:
PLS-00302: 必须说明 ‘SET_NO_OUTLINES’ 组件
ORA-06550: 第 1 行, 第 15 列:
PL/SQL: Statement ignored
EXP-00000: 导出终止失败
将PATH路径添加原先9i的ORACLE_HOME/bin目录即可导出。
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.
Please Refer to Basic Compatibility Section in Note 132904.1
References
Note 132904.1 – Compatibility Matrix for Export & Import Between Different Oracle Versions