DB13 Update stat error

[Former Member]

Hi,

DB13 update stat's i am getting below error plz kindly help me.

BR0301E SQL error -20000 at location stats_ind_collect-3, SQL statement:

'BEGIN DBMS_STATS.GATHER_INDEX_STATS (OWNNAME => '"SAPSR3"', INDNAME => '"/BIC/B0000460000KE"', ESTIMATE_PERCENT => 30, DEGREE =

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

ORA-06512: at "SYS.DBMS_STATS", line 10613

ORA-06512: at "SYS.DBMS_STATS", line 10648

ORA-06512: at line 1

BR0886E Checking/collecting statistics failed forindex SAPSR3./BIC/B0000460000KE

kvl

[former_member204746 · Accepted solution]

2 possibilities:

1. go into SE14 and rebuild index of /BIC/B0000460000KE

2. run report RSAR_PSA_PARTITION_CHECK as per SAP note 1042182

solution 2 should be a permanent solution.

[Former Member]

Hi Kvl,

You have to rebuild the index.

Check Note 633914 - Error when executing DBMS_STATS

Hope this helps.

Cheers....,

Raghu