-
Hi all,
When I used the command ALTER TABLE move table_name move tablespace A
after the move is complete, the index belong to that table become UNUSUABLE instead of VALID. Why the index become unusable???
What I did was drop the index and create the new index but I am trying to find out why index is unuseable???
thanks
-
Index becomes invalid because the rowids in the table have changed. You can use ALTER INDEX xyz REBUILD instead of dropping/recreating.
Jeff Hunter
-
Thanks Jeff as always
Have a great weekend!!!
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
|