-
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...
Radhakrishnan.M
-
Bit Map Index can be rebuilt. Only online is not supported.
-
-
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;
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|