Hi All,
In BW UpdateStats are cancelling daily. with the log :
BR0301E SQL error -20000 at location stats_ind_collect-3, SQL statement:
'BEGIN DBMS_STATS.GATHER_INDEX_STATS (OWNNAME => '"SAPDAT"', INDNAME => '"/BIC/B0000601000KE"', ESTIMATE_PERCENT => NULL, DEGREE => NULL, NO_
ORA-20000: index "SAPDAT"."/BIC/B0000601000KE" or partition of such index is in unusable state
ORA-06512: at "SYS.DBMS_STATS", line 10712
ORA-06512: at "SYS.DBMS_STATS", line 10747
ORA-06512: at line 1
BR0886E Checking/collecting statistics failed for index SAPDAT./BIC/B0000601000KE
Kindly suggest.
Thanks & Regars!!
Ahmed.