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

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

 

 

 

 

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	11.2.0.2 11.2.0.1
Platforms affected	Generic (all / most platforms affected)

Fixed:

This issue is fixed in

12.1 (Future Release)

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.