ORA-20001 selecting from DBA_TAB_STATISTICS
SQL> SELECT DISTINCT STALE_STATS FROM DBA_TAB_STATISTICS;
SELECT DISTINCT STALE_STATS FROM DBA_TAB_STATISTICS
*
ERROR at line 1:
ORA-20001: BIN$N5R12EQSEATGQKJAIQFV8G==$0 is an invalid identifier
ORA-06512: at "SYS.DBMS_STATS", line 2082
ORA-06512: at "SYS.DBMS_STATS", line 2098
ORA-06512: at "SYS.DBMS_STATS", line 26789
ORA-06512: at line 1
SELECT DISTINCT STALE_STATS FROM DBA_TAB_STATISTICS
*
ERROR at line 1:
ORA-20001: BIN$N5R12EQSEATGQKJAIQFV8G==$0 is an invalid identifier
ORA-06512: at "SYS.DBMS_STATS", line 2082
ORA-06512: at "SYS.DBMS_STATS", line 2098
ORA-06512: at "SYS.DBMS_STATS", line 26789
ORA-06512: at line 1
SQL> SHOW USER
USER is "SYS"
SQL> PURGE DBA_RECYCLEBIN;
DBA Recyclebin purged.
SQL> SELECT DISTINCT STALE_STATS FROM DBA_TAB_STATISTICS;
STA
---
---
NO
YES
YES
发现一个类似bug(11.2.1和11.2.2都有补丁)，不过碰到的这个问题没有去打补丁，purge回收站解决的 :
| Bug 9930151 - ORA-20001 selecting from DBA_TAB_STATISTICS [ID 9930151.8] | |||||
|
| |||||
| 修改时间 09-FEB-2011 类型 PATCH 状态 PUBLISHED | |||||
Bug 9930151 ORA-20001 selecting from DBA_TAB_STATISTICS
This note gives a brief overview of bug 9930151.The content was last updated on: 07-FEB-2011
Click here for details of each of the sections below.
Affects:
Product (Component) Oracle Server (Rdbms) Range of versions believed to be affected Versions BELOW 12.1 Versions confirmed as being affected Platforms affected Generic (all / most platforms affected)
Fixed:
This issue is fixed in
Symptoms: |
Related To: |
|
|
Description
ORA-20001 errors are possible when querying statistics data dictionary views if table names have non-alphanumeric characters. This includes if objects are present in the recycle bin. eg: SELECT STALE_STATS FROM DBA_TAB_STATISTICS WHERE TABLE_NAME = '/X/Y'; ^ ORA-20001: /X/Y is an invalid identifier ORA-06512: at "SYS.DBMS_STATS", line 2082 ... Rediscovery Notes: If you are using table names with non-alphanumeric characters, and querying the statistics dictionary views for these tables gives an ORA-20001 error you are probably hitting this bug.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/756652/viewspace-694625/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
MySQL如何避免使用swap(ZT)
请登录后发表评论
登录
全部评论
