2012-05-25

ORA-20001 with DBMS_STATS dba_tab_statistics

You may encounter the error bellow https://forums.oracle.com/forums/thread.jspa?threadID=2296034
elect * from sys.dba_tab_statistics
ORA-20001: BIN$PV5XQQHLSAYJ0KPMEY1MHG==$0 is an invalid identifier
ORA-06512: in "SYS-DBMS_STATS", Line 2082
ORA-06512: in "SYS-DBMS_STATS", Line 2098
ORA-06512: in "SYS-DBMS_STATS", Line 26789



Soluition: purge dba_recyclebin;

See also the bug bellow

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-SEP-2011
 Click here for details of each of the sections below.

Affects:

Product (Component)Oracle Server (Rdbms)
Range of versions believed to be affectedVersions BELOW 12.1
Versions confirmed as being affected
Platforms affectedGeneric (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.

Niciun comentariu:

Trimiteți un comentariu