Alter table move taking long time I'm currently trying to compress a table in Oracle with the following statements:

ALTER TABLE MYTABLE COMPRESS FOR OLTP;
ALTER TABLE MOVE;


My question is: the MOVE operation is taking forever and unfortunately I forgot to state the ONLINE clause.

If I cancel it, will I lose data? Or is there any way to find out how long it will take?
There's no problem in canceling the MOVE operation. Oracle just rolls back.

Progress information can often be gathered from [g]v$session_longops, looking for sessions with time_remaining &gt; 0 (or the specific session you're interested in when you know that).