Skip to Content
0
Former Member
Mar 25, 2009 at 05:36 AM

UpdateStats cancelling daily.

37 Views

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.