ORA-20000: index "SAPSR3"."/xxxxxxxxxxxx"  or partition of such index is in unusable state

 

Error in log file:

BR0301E SQL error -20000 at location stats_tab_collect-20, SQL statement: 'BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPSR3"', TABNAME => '"xxxxxxx"', ESTIMATE_PERCENT => 10, METHOD_OPT => 'FOR ALL COLUMNS SIZE 1'
ORA-20000: index "SAPSR3"."/xxxxxxxxxxxx"  or partition of such index is in unusable state
ORA-06512: at "SYS.DBMS_STATS", line 14537
ORA-06512: at "SYS.DBMS_STATS", line 14558
ORA-06512: at line 1
BR0886E Checking/collecting statistics failed for table SAPSR3.xxxxxx


*****************************************************************************
#sqlplus / as sysdba

SQL> select table_name, index_name from dba_indexes where status = 'UNUSABLE';

TABLE_NAME                     INDEX_NAME
------------------------------ ------------------------------
/BIC/B0000219000               /BIC/B0000219000KE

SQL> ALTER INDEX "SAPSR3"."/BIC/B0000219000KE" REBUILD; (Be carreful with big tables)
SQL> exit
*****************************************************************************

Redo the statistics...