Oracle Database Discussions

Hi All,

Oracle v11.2.0.3

I have a big index organized table. Recently, due to some business logic change, as a one-off activity, we have deleted more than half of the data in there.
Now to make it efficiant for read, I am planning to do ALTER TABLE...MOVE on that IOT, to make it compact (as its mainly used for read and rarely updated).

When I am running ALTER TABLE... MOVE, for some un-imaginable reason, if the alter command failed. I am assuming the original IOT will NOT be affected and will be available for normal use. Am I correct ?

Any idea how this operation is done internally? does it use TEMP space?

Thanks in advance