DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Thursday, July 6, 2017

ORA-20001:BIN$5AYDAYFHTZIUS2DAU/WO7Q==$0 is an invalid identifier  &  ORA-06512:



This issue is caused by to while we are running below sql.

select
    table_name,
    stale_stats,
    last_analyzed
from
    dba_tab_statistics
 where
    owner = OWNER=>'<USER NAME>'
order by
    last_analyzed desc, table_name asc;
ast_analyzed desc, table_name asc;

ERROR at line 10:
ORA-20001: BIN$5AYDAYFHTZIUS2DAU/WO7Q==$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
******************************************************************
exec dbms_stats.gather_table_stats(OWNER=>'<USERNAME>',TABNAME=>'<TABLENAME>',cascade=>TRUE, ESTIMATE_PERCENT=>DBMS_STATS.AUTO_SAMPLE_SIZE);

                                     *
ERROR at line 10:
ORA-20001: BIN$5AYDAYFHTZIUS2DAU/WO7Q==$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

Solution:-

SQL> PURGE DBA_RECYCLEBIN;
SQL> alter system flush shared_pool;



1 comment: