Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

rebuild partition index

650105Jun 25 2009 — edited Jun 29 2009
hello
i have unusable a index. Now i want to rebuild index for this i have to rebuild partition and tablespace in two different command like

ALTER INDEX index_name REBUILD PARTITION p1;
ALTER INDEX index_name REBUILD PARTITION p1 TABLESPACE INDX_TS;
now my question is when i run first command and check status fof index it show usable. Similarly when i ran only 2nd command also rebuild successfully. if i ran only 2nd command work fine?
why it show usable after only rebuild partition?


i have generate script for all user indexes like this

Select 'ALTER INDEX '|| index_name ||' rebuild partition ' || PARTITION_NAME ||';' from USER_IND_PARTITIONS
Select 'ALTER INDEX '|| index_name ||' rebuild partition ' || PARTITION_NAME || ' TABLESPACE ' || tablespace_name ||';' from USER_IND_PARTITIONS
This post has been answered by 26741 on Jun 29 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 27 2009
Added on Jun 25 2009
8 comments
76,738 views