How to rebuild an Index ?


Sql> alter index [index_name] rebuild online;

Before that check your tablespace should have enough free space. In rebuilding an index a copy of existing index is created in the same tablespace. Once this is done old one is dropped and new starts getting used. You can find out size of your index by

Sql> select segment_name,bytes/(1024*1024) from dba_segments where segment_name like ‘index_name’;

No comments:

Post a Comment