alter table shrink space
I have a table which oracle recommends to shrink via alter table shrink space command (version 10.2.0.3) and release almost all space (46G out of 47 or so). I have not tried this in production yet. From what I read there seems to be no downside to this. The table stays available for reads and updates (the performance will be affected however). The data will not be affected too. And if I have to I can cancel the command in the middle and resume at a later time. Whatever data have been reorged will stay that way.
But am I missing something? Are there any issues with this that others have ran into?