problem in update database statistics

[Former Member]

when i run

update database statistics

when it completed it becomes red

then i check it out

log file there i found error

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

'BEGIN DBMS_STATS.GATHER_INDEX_STATS (OWNNAME => '"SAPECC"', INDNAME => '"SNAP~0"', ESTIMATE_PERCENT => NULL, DEGREE => NULL, NO_INVALIDATE => FALSE); END;

ORA-00904: : invalid identifier

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

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

ORA-06512: at line 1

BR0886E Checking/collecting statistics failed for index SAPECC.SNAP~0

BR0280I BRCONNECT time stamp: 2009-11-03 10.56.12

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

'BEGIN DBMS_STATS.GATHER_INDEX_STATS (OWNNAME => '"SAPECC"', INDNAME => '"SNAP~DSX"', ESTIMATE_PERCENT => NULL, DEGREE => NULL, NO_INVALIDATE

ORA-00904: : invalid identifier

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

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

ORA-06512: at line 1

BR0886E Checking/collecting statistics failed for index SAPECC.SNAP~DSX

what will i do

please suggest something

[Former Member]

Hi Anant ,

I think you need to update your brtool patch as described in [Note 874911 - Workaround for ORA-31603 (BR0996E) during reorganization|https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=874911].

Hope it will solve your problem as it is due to bug in oracle.

Regards,

Gagan Deep Kaushal

[markus_doehr2]

What exact Oracle version and patch do you use?

Markus