Re: Online "tablespace" reorg ?

Hi I believe you have to be using ASSM, to use shrink

thanks for the feedback on ASSM

bob

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.
>
>

--
http://www.freelists.org/webpage/oracle-l