missing index

[Former Member]

hi guruji

i found following error in sap

BR0970W Database administration alert - level: ERROR, type: MISSING_INDEX, object: (table) SAPSR3.DOKCLU#$

BR0970W Database administration alert - level: ERROR, type: MISSING_INDEX, object: (table) SAPSR3.MLOG$_DOKCLU

in dba_index i check index is thare now i cant under stad what i do

sap =ecc6

oracle10g 10.2

from nainesh suthar

[stefan_koehler]

Hello Nainesh,

have you tried to reorganize the table DOKCLU online?

All these segments "DOKCLU#$" and "MLOG$_DOKCLU" are created by the BR*Tools (DBMS_REDEFINITION) by an online reorganization.

If you don't need them anymore (for example for an aborted online reorg) .. you can delete them or use the BR*Tools to clean up.

shell>brspace -u / -f tbreorg -t "*" -a cleanup

Check sapnote #741478 for more information.

Regards

Stefan

[Former Member]

thankus sir