环境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 过程已成功完成。
一切正常
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/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7199859/viewspace-17254/