Rebuild an Oracle Database Index via SQLPLUS / RSANAORA / BRTOOLS

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;

Rebuild an Oracle Database Index via SQLPLUS / BRTOOLS / RSANAORA

2 – REBUILD via RSANAORA Program

Go to SE38 and RUN the Program RSANAORA

SE38 –> RSANAORA

Rebuild an Oracle Database Index via SQLPLUS / BRTOOLS / RSANAORA

F8 – EXECUTE

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

Rebuild an Oracle Database Index via SQLPLUS / BRTOOLS / RSANAORA

F8 – EXECUTE

Rebuild an Oracle Database Index via SQLPLUS / BRTOOLS / RSANAORA

3 – REBUILD via BRTOOLS

Go to OS level and execute BRTOOLS command

Select ;

3 – Segment Management

2 – Rebuild indexes

Rebuild an Oracle Database Index via SQLPLUS / BRTOOLS / RSANAORA

 7 – Index Name and Continue

Rebuild an Oracle Database Index via SQLPLUS / BRTOOLS / RSANAORA

Rebuild an Oracle Database Index via SQLPLUS / BRTOOLS / RSANAORA

Operation has completed…

 

 

Leave a Reply


three − 2 =

Blogroll