Skip to Content
0
Former Member
Mar 02, 2009 at 11:21 AM

Error in Update optimizer statistics - index is in unusable state

351 Views

Hello,

we have this error in log Check and update optimizer statistics:

12.02.2009 23:21:20 'BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPPB1"', TABNAME => '"/BIC/FZPPC0002"', ESTIMATE_PERCENT => 10, METHOD_OPT =

12.02.2009 23:21:20 ORA-20000: index "SAPPB1"."/BIC/FZPPC0002~010" or partition of such index is in unusable state

12.02.2009 23:21:20 ORA-06512: at "SYS.DBMS_STATS", line 13452

12.02.2009 23:21:20 ORA-06512: at "SYS.DBMS_STATS", line 13472

12.02.2009 23:21:20 ORA-06512: at line 1

12.02.2009 23:21:20 BR0886E Checking/collecting statistics failed for table SAPPB1./BIC/FZPPC0002

i can temporary fix this problem when i delete and recreate index via SE14, but this help only for one next running update statistics, every next running update statistics has same error: index "SAPPB1"."/BIC/FZPPC0002~010" or partition of such index is in unusable state. Exist any definitive solution for this problem. Thanks