rebuilding bitmap and function based indexes.

Hi,

I want to rebuild a unusable bitmap index and disabled function based index .

I just want to make sure below syntax is correct for the same .


for bitmap

alter bitmap index "OWNER"." Index_name"
nologging rebuild tablespace data_DATA storage( initial 16384 next 57344);

for fuction based index.

alter index enable "OWNER"." Index_name"
nologging rebuild tablespace USERS storage( initial 57344 next 516096);


thanks in advance !

tom

both Bitmap indexes and function based indexes cannot be rebuilt.They have to be dropped and recreated...

Bit Map Index can be rebuilt. Only online is not supported.

Thanks ...Tamil.

Bitmap index can be rebuild
and function based index can be enable using following sql

alter "OWNER"." Index_name"
nologging rebuild tablespace DATA storage( initial 16384 next 57344);

for fuction based index.

alter index owner.index_name enable;