When you are required to rebuild an index that is in an unusable, missing, or bad index status then you can use several tools like i would like to share with you below…

For our example we are going to try to rebuild index ZAUFK~A 

1 – REBUILD via SQLPLUS

You have to connect to the ORACLE database via SQLPlus over OS level and execute the following command.

SQL > Alter index <Owner>.<Index Name> rebuild online;

2 – REBUILD via RSANAORA Program

Go to SE38 and RUN the Program RSANAORA

SE38 –> RSANAORA

F8 – EXECUTE

Select “INDEX” and “Alter Index Rebuild Online” (if it’s a small index) radio buttons and input “INDEX NAME”

F8 – EXECUTE

3 – REBUILD via BRTOOLS

Go to OS level and execute BRTOOLS command

Select ;

3 – Segment Management

2 – Rebuild indexes

 7 – Index Name and Continue

Operation has completed…