Hi I believe you have to be using ASSM, to use shrink
thanks for the feedback on ASSM
z b wrote:
Since you're on 10g, to reset the HWM, have you tried:
alter table <tab name> shrink space;
I haven't played with it extensively, but it is *supposed* to reset it online, allowing access (with short locks while it munges the Data Dictionary).
FWIW, we've used ASSM in DSS and OLTP without any issues.