Hi all,

I have two related questions about "alter table ... move " command.

1. If the table I plan to move is a regular table, then the rowid of each column and the relative location of data in the table will change after the move, right? If this is correct, then all the indexes of the table will be unvalid. So does oracle automatically rebuilds the indexes of the table? I couldn't find anything about this from oracle documentation.

2. If the table is partitioned, then according to oracle documentation, all indexes will be marked unusable. What does that mean? Do I have to re-create all indexes after I move a partitioned table?

Please help! Thanks!

Tianhua