Rebuid index.

[Former Member]

Hi Guys

I am facing an error during Update statistics as :

Index SAPR3.TPFET__0 is unbalanced - please rebuild the index.

I have rebuit the index and it was rebuild successfully.

But, when i ran update statistics again, same error appeared again.

I dont have any DB Expert to assist me and I need to fix it.

Please let me know how?

Regards

[former_member204746]

you must be using Oracle 9i or below.

try this:

sqlplus "/ as sysdba"

alter table sapr3.TPFET monitoring;

exit

now run update stats again.

problem should go away for this table's indexes.

[Former Member]

Hi

Its Oracle 9.2.0.7

I did it but problem still persists.

I even tried to rebuilt the index from SAP R3 but result was same.

Regards

[former_member204746]

I'm surprised it did not work with my commands.

try to update BRTOOLS to see if it could help.

anyways, Oracle 9i is out of support (or will be soon), upgrade to Oracle 10g, it will surely resolve this issue.

Until then, this is just a nuisance and not an error. you can ignore.

[Former Member]

Hi Eric

we are in the process of upgrading to 10g patch level 2.

It should be done Nov month End..

Anyways thanks..

Regards

Ricky

[former_member204746]

consider Oracle 10.2.0.4 which is now supported.

[Former Member]

Smashing Eric

Index has been rebuilt.

1. i followed Note 444287.

2. then i rebuilt the index and finally i ran

3. alter table sapr3.TPFET monitoring;

then ran update statistics and it ran absolutely fine.

But i still dont know which step has worked as medicine.

Many Thanks,

Cheers

Ricky

[Former Member]

Hi,

Check following sap note

Note 439783 - BR986W Index ... is unbalanced - please rebuild the index

Note 444287 - Checking the index storage quality

regards,

kaushal