alter table shrink space!!~ help!
hi guys,
1) i issue a shrink space commands and it is taking ages to completed.
2) generated tons of redo and undo and i am near my harddisk max space.
q1) if i were to kill the session of now,
will there be alot of rolling back to be done ?
isn't alter table a DDL statement, so will the row movement be commited periodically or only after the whole statement has completed ?
which means that the rollback if i kill off the session will have to rollback all the way to the time whereby i issue the shrink statement ?
Regards,
Noob