DB13 - Update Statistics Error - BR0301E

[Former Member]

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?

[Former Member · Accepted solution]

HHi Bill,

Execute the report "RSAR_PSA_PARTITION_CHECK" with the check the repair flag and write down technical PSA name into the boxes. Then, execute the report.

At the end of the report, green light should be seen at the log output.

After that you shouldn't get this error, again.

Best regards,

Orkun Gedik

[Former Member · Accepted solution]

I just ran the program for the tables involved.

I will let the DB13 - Update Stats job run for a few days to see if I get the error.

[Former Member · Accepted solution]

Thanks.

DB13 - Update Stats is working.

[Former Member · Accepted solution]

Thank you Orkun,

your solution solved my issue also. This is also written in Note 1042182. I have just run the report without entering any technical PSA names in the boxes and it worked.

If anybody gets ora-00020 error when executing update statics after running the above report, then just wait for 15 min. and try again, it will work. (You dont have to try the below solution, it is unnecessary).

http://www.shutdownabort.com/errors/ORA-00020.php

Regards,

Mohan.