Originally posted by shailendra
Well from this comand your tables will get transfered but the index won't get transfered so you have to rebuild all the Indexes.

Shailendra
Hi,
This is not exactly the reason why indexes get 'UNUSABLE';
The reason is that in the index-leafs where the rowid points to the rows in the table-block get invalid, because the table-block has moved.
If you would move the index-blocks too the rowid would still be invalid;

But if there would be an additional clause : INCLUDING INDEXES STORAGE ...

this would be great indeed.

Orca