联系:手机/微信(+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.失误总结
自己的自以为是让他忙碌了几个小时,深表歉意。人家把你当做专家,你就应该对人家负责任。用认真的心态去帮别人解决问题,不要以为自己就要离开,用种不负责任的态度去处理事情,更不要以为这些东西,自己已经很懂了,不认真对待。
可是我安装的是oracle 10g 客户端的,也是出现这样的情况,那这个该怎么解决呢