运行收集统计信息dbms_stats.gather_table_stats包的bug

上一篇 / 下一篇 2007-12-28 09:39:24 / 个人分类：学习

环境winxp+oracle 9.2.0.1
C:>sqlplus

SQL*Plus: Release 9.2.0.1.0 - Production on 星期四 7月 5 15:00:48 2007

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

请输入用户名: sys/abcdefg@test as sysdba

连接到:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
SQL> exec dbms_stats.gather_table_stats(ownname=>'paul', tabname=>'T');
BEGIN dbms_stats.gather_table_stats(ownname=>'paul', tabname=>'T'); END;

*
ERROR 位于第 1 行:
ORA-06521: PL/SQL: Error mapping function
ORA-06512: at "SYS.DBMS_STATS", line 9643
ORA-06512: at "SYS.DBMS_STATS", line 9657
ORA-06512: at line

网上查了下,说可能是bug 需要升级到9204,于是在自己电脑上升级到9204版本的数据库
C:\Documents and Settings\Paul Yi>sqlplus "/as sysdba"

SQL*Plus: Release 9.2.0.4.0 - Production on 星期四 7月 5 16:44:34 2007

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

连接到:
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

SQL> EXEC dbms_stats.gather_table_stats(ownname => 'PAUL',tabname => 'T',method_opt => 'FOR ALL INDE
XED COLUMNS SIZE REPEAT',cascade => TRUE);

PL/SQL 过程已成功完成。

一切正常