I have couple segment that need to be shrink and below is what I am trying to run:
alter table ........ enable row movement
alter table ........ shrink space
According to Oracle, during the short space release phase, any cursors referencing this segment may be invalidated and queries on the segment could be affected. Based on this statement, I don't think I can do it online while my application is still running, am I correct? Any other alternatives for me to run this online while the app is still running?