執行收集統計資訊dbms_stats.gather_table_stats包的bug

paulyibinyi發表於2007-12-28
環境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 過程已成功完成。

一切正常

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/7199859/viewspace-17254/，如需轉載，請註明出處，否則將追究法律責任。

相關文章