Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm currently trying to compress a table in Oracle with the following statements:


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?

share|improve this question

migrated from Jul 6 '13 at 7:02

This question came from our site for professional and enthusiast programmers.

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 > 0 (or the specific session you're interested in when you know that).

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.