oracle pls-00302 ora-06550,案例:Oracle报错PLS-00302 DBA在exp导出数据报错PLS-00302:component‘SET_NO_OUTLINES mus...

天萃荷净

运维DBA在使用逻辑导出EXP导出数据时报错PLS-00302: component ‘SET_NO_OUTLINES’ must be declared，分析原因为客户端版本问题导致

今天接到测试报告，他的客户端不能导出数据库

1.逻辑导出exp时报错

Export started on 2012-1-16 15:30:05

D:\oracle\product\10.2.0\client_3\BIN\exp.exe parfile=C:\WINDOWS\Tmp\plsexp.par

EXP-00056: 遇到 ORACLE 错误 6550

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 finished on 2012-1-16 15:30:07

2.在服务器上导出exp测试

[oracle@localhost tmp]$ exp "'/ as sysdba'" owner=testxuchao \> file=/tmp/oracleplus.dmp log=/tmp/oracleplus.log

Export: Release 9.2.0.4.0 - Production on Mon Jan 16 15:36:38 2012

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to