原来同事问的问题
我开玩笑说收费,他马上说有机会请吃饭
在网上帮前同事解决过n多次问题,都说请吃饭
其实很少能吃到,呵呵
说导出的时候报错
还贴过来了报错信息
EXP-00056: 遇到 ORACLE 错误 6550
ORA-06550: 第 1 行, 第 41 列:
PLS-00302: 必须说明 'SET_NO_OUTLINES' 组件
ORA-06550: 第 1 行, 第 15 列:
PL/SQL: Statement ignored
EXP-00000: 导出终止失败
查了下,这个是个常见问题
导出的时候用高版本客户端导出低版本数据库的时候可能出现
oracle给出了解释
在文档Doc ID: NOTE:339062.1 中,如下
-------------------
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.
-- The End --
-------------
换个客户端就好了
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/13177610/viewspace-702664/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/13177610/viewspace-702664/