Skip to Content
0
Former Member
Jul 19, 2011 at 05:17 PM

DB13 - Update Statistics Error - BR0301E

233 Views

I am getting this error:

BR0301E SQL error -20000 at location stats_tab_collect-20, SQL statement:

'BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPSR3"', TABNAME => '"/BIC/B0000267000"', ESTIMATE_PERCENT => NULL, METHOD_OPT => 'FOR ALL COLUMNS SIZE 1', DEGREE => NULL, GRA

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

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

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

ORA-06512: at line 1

BR0886E Checking/collecting statistics failed for table SAPSR3./BIC/B0000267000

I am using Oracle 10.2.0.4 on RedHat/Linux

I keep rebuilding the unsuable index but still get the error.

Any advice?