ORA-20001: BIN$12EX+RAYNZZGQB4KEQF0BW==$0
is an invalid identifier
ORA-06512: at "SYS.DBMS_STATS",
line 2242
ORA-06512: at "SYS.DBMS_STATS",
line 2258
ORA-06512: at "SYS.DBMS_STATS",
line 30041
查找MOS，确定为bug，客户数据库版本为11.2.0.2，该bug在11.2.0.3中修复
Bug 9930151 ORA-20001 selecting from DBA_TAB_STATISTICS
This note gives a brief overview of bug 9930151.
The content was last updated on: 28-JUN-2013
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.
|
Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. For questions about this bug please consult Oracle Support. |