Update Statistics Error on DB13 – SQL error -20000 at location stats_ind_collect-3

Posted on Leave a commentPosted in Oracle Database

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 […]

SPAM / SAINT Update

Posted on 2 CommentsPosted in ABAP, Update

When we try to update a Support Package, this issue can occur: (requires at least version xxxx of the Support Package Manager) Details: (version is too low) This is because the SPAM and SAINT are not up to date. To check the current SPAM version, you can also go to tcode SPAM, and check the […]