Re: clean up the temp space

senthil wrote:
>
> hi,
> is there any way to clean-up the temp space.
> any help is appreciated.
> thanks
> -senthil
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

If its a temporary tablespace, then don't. Its meant to stay "full"...

If you really want to, then set the pctincrease to 0 (even if it already is). This will give SMON a kick and tell it to clean it up (it may take a few minutes).

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse