Hi everyone,
I'm trying to reclaim the space in a table that used to have 40 millions rows by using ALTER TABLE MOVE command ( the table has 2 mil rows now). I tried this command on a table that is a tenth of the size of the table above and the ALTER TABLE MOVE command took 30 minutes. Would it fair to say that the 40+ millions table will take around 300 minutes to complete? Is there a way to project this run? How can I improve the performance of alter table move ? Would create temp table/truncate/re-insert method be a better way to do this? When this ALTER command is in progress can we have DMLs command on this table. Thanks for your help.