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!

moving index to a new tbs online

ACR80Apr 20 2007 — edited Apr 20 2007
Hi everybody,
i need to separate data from index so i decided to move (rebuild) index to a new tbs.
i use the command:
alter index index_name rebuild tablespace idx_tbs online;

So far so good..
But i'm curious.. what is oracle doing to accomplish that?

I run a query on dba_indexes and noted a strange thing..
while rebuilding the first index the others are marked as unusable.. Whoa!
I suppose they should be valid until the new one is ready!

Am i missing something?
I'm using a 10g 10.1.0.5 to do my tests..

Any ideas?

Thanks
Acr
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 18 2007
Added on Apr 20 2007
8 comments
943 views