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

Other related posts: