hi,
"alter table .. move .."
will cause all the indexes of that table unusable.
you can not make any queries that involves indexed columns
in where clause.
you can not analyze that table.
you have to rebuild the table. then only you can do
normal operations on that table.
bye now.
-raja




Reply With Quote