Index rebuild of Table in different tablespaces

 ·         Get the 

(A) Index and 

(B) Tablespace name

for the required table from brtools

 ·         brtools --> 3 - Segment management

 

 ·         7 - Additional segment functions

 ·         2 - Show indexes

 ·         8 - Database tables (table)

·         Now check again in brtools after rebuilt of index

·         Once the index rebuilt is done, run update optimizer statistics from db13