Re: Online "tablespace" reorg ?

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.  

<snip redundancy>
--
http://www.freelists.org/webpage/oracle-l

Other related posts: