某客户数据库在执行查询select * from DBA_TAB_STATISTICS报如下错误：

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

ORA-06512: at line 1
查找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

11.2.0.2

11.2.0.1

11.1.0.7

Platforms affected Generic (all / most platforms affected)

Fixed:

This issue is fixed in

12.1.0.1 (Base Release)

11.2.0.3 (Server Patch Set)

Symptoms:	Related To:
Error May Occur ORA-20001	Recycle Bin DBA_TAB_STATISTICS

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.

ITPub博客

ORA-20001: ORA-06512: at "SYS.DBMS_STATS", line 2242

Affects:

Fixed:

Symptoms:

Related To:

Description

最新文章

*Product (Component)*	Oracle Server (Rdbms)
*Range of versions believed* to be affected**	Versions BELOW 12.1
*Versions confirmed* as being affected**	11.2.0.2 11.2.0.1 11.1.0.7
Platforms affected	Generic (all / most platforms affected)