Hello all,
I want to share a simple solution for the issue below, when scheduled "Update Statistics" on DB13:
Error details log:
BR0301E SQL error -20000 at location stats_ind_collect-3, SQL statement: 'BEGIN DBMS_STATS.GATHER_INDEX_STATS (OWNNAME => '"SAPSR3"', INDNAME => '"/ABC/INDEXNAME~010"', ESTIMATE_PERCENT => 3, DEGREE => NULL, NO_INVALIDATE => FALSE); END;' ORA-20000: index "SAPSR3"."/ABC/INDEXNAME~010" or partition of such index is in unusable state ORA-06512: at "SYS.DBMS_STATS", line 18683 ORA-06512: at "SYS.DBMS_STATS", line 18724 ORA-06512: at line 1 |
Solution
As showing in the log, the index is unusable, so the solution is simple, rebuild it through oracle.
Log on the system server as oraSID, and execute:
sqlplus "/ as sysdba"
alter index "SAPSR3"."/ABC/INDEX_NAME" rebuild online;
exit;
Regards,
Richard W. L. Brehmer
rbrehmer.com
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
13 | |
11 | |
5 | |
5 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 |