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
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 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.
Niciun comentariu:
Trimiteți un comentariu