Error running DB13 - Update and check Optmizer Statistics at SOLMAN

[Former Member]

Hello people

I'm facing an error when the task Update and check Optimizer Statistics is running ate DB13.

BR0280I BRCONNECT time stamp: 2010-09-01 01.06.53

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

'BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPSOL"', TABNAME => '"/BIC/B0000029000"', ESTIMATE_PERCENT => 30, METHOD_OPT => 'FOR ALL COLUMNS SIZE 1', DEGREE => NULL, GRANULARITY => 'ALL', CASCADE => TRUE, NO_INVALIDATE => FALSE); END;'

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

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

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

ORA-06512: at line 1

Coul you please help me with this issue?

Regards

[former_member204746]

permanent solution:

do not update DB_STATS at the same time as updating /BI* tables.

until then, simply rebuild this indexes online:

sqlplus / as sysdba

alter index "SAPSOL"."/BIC/B0000029000KE" rebuild online;

exit;

good luck.

[former_member709110]

Hi ,

Refer to the Note 633914 - Error when executing DBMS_STATS . It has mention about the issue and solution. There are several SAP Notes on REBUILD (like 682926, 1485841 , etc) go through them before you excute REBUILD , just in case you decide to do so.

Regards,

Neel