联系：手机/微信(+86 17813235971) QQ(107644445)
标题：PLS-00302: component ‘SET_NO_OUTLINES’ must be declared
作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
今天接到测试报告，他的客户端不能导出数据库
1.报错如下
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.服务器上导出
[oracle@localhost tmp]$ exp "'/ as sysdba'" owner=testxuchao \ > file=/tmp/xifenfei.dmp log=/tmp/xifenfei.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: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.4.0 - Production Export done in US7ASCII character set and AL16UTF16 NCHAR character set server uses ZHS16GBK character set (possible charset conversion) About to export specified users ... . exporting pre-schema procedural objects and actions . exporting foreign function library names for user TESTXUCHAO . exporting PUBLIC type synonyms . exporting private type synonyms . exporting object type definitions for user TESTXUCHAO About to export TESTXUCHAO's objects ... . exporting database links . exporting sequence numbers . exporting cluster definitions . about to export TESTXUCHAO's tables via Conventional Path ... . . exporting table COMPANY_CON 0 rows exported . . exporting table SMP_VDD_OPERATIONS_TABLE 0 rows exported . . exporting table TAB_XN_NXT_CONSULTATION 0 rows exported EXP-00091: Exporting questionable statistics. …………………… EXP-00091: Exporting questionable statistics. . . exporting table TAB_XN_PY 0 rows exported EXP-00091: Exporting questionable statistics. EXP-00091: Exporting questionable statistics. . . exporting table TAB_XN_PY_DICT 25433 rows exported EXP-00091: Exporting questionable statistics. EXP-00091: Exporting questionable statistics. . exporting synonyms . exporting views . exporting stored procedures . exporting operators . exporting referential integrity constraints . exporting triggers . exporting indextypes . exporting bitmap, functional and extensible indexes . exporting posttables actions . exporting materialized views . exporting snapshot logs . exporting job queues . exporting refresh groups and children . exporting dimensions . exporting post-schema procedural objects and actions . exporting statistics Export terminated successfully with warnings.
服务器上执行exp成功了，我很自然的说了句，是客户端的问题，然后和测试说，可以端重新装下再试试看(因为他装了两个客户端，我是怀疑变量等原因导致)。当他装好后，然后和我说，还是不行，我开始怀疑是版本的问题，然后对比了下今天他的报错，和数据库版本，发现果真是两边版本的问题(数据库服务器版本:9.2.0.4，客户端版本:10.2.0.1)，解决问题，让他装一个低版本的客户端，再装个高版本的客户端，然后在根据导出数据的版本，选择不同版本的exp。
3.失误总结
自己的自以为是让他忙碌了几个小时，深表歉意。人家把你当做专家，你就应该对人家负责任。用认真的心态去帮别人解决问题，不要以为自己就要离开，用种不负责任的态度去处理事情，更不要以为这些东西，自己已经很懂了，不认真对待。
加我QQ
可是我安装的是oracle 10g 客户端的，也是出现这样的情况，那这个该怎么解决呢