MOVE TABLES TO DIFFERENT TABLESPACE

[ashley75]

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

[marist89]

Index becomes invalid because the rowids in the table have changed. You can use ALTER INDEX xyz REBUILD instead of dropping/recreating.

[ashley75]

Thanks Jeff as always


Have a great weekend!!!