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