Rebuild the index partitions

[Former Member]

Hi!

After the job _Update stats we received the following warning about the rebuild of index:

BR0986W Partitioned index SAPHBT./BIC/B0000054007~0 is unbalanced - please rebuild the index partitions

Question:

What is the procedure to do this?

(tcode SA38 --> RSANAORA)

Thank you!

[stefan_koehler · Accepted solution]

Hello Holger,

please check sapnote #439783 ... there is a step-by-step guide.

Regards

Stefan

[former_member204746]

solution 1:

sqlplus "/ as sysdba"

alter table SAPHBT."/BIC/B0000054007" monitoring;

solution 2:

upgrade to Oracle 10g.