alter tablemove tablespace
works after 9i and locks the entire table for the duration of the operation.
Not sure but I think the corresponding indexes will be made unisable and must be rebuilt.
It is possible to be necessary to issue
alter tableenable row movement;
before issuing alter table move
Regards




Reply With Quote