Re: temp tablespace

senthil wrote:
>
> Excellent, it worked well now. i changed the database state to
> permanent and waited for few minutes and set back to temporary. it was
> free now. can anyone explain me whats the oracle process/concept runs
> behind this.
> thanks for your help/suggestions.
> -senthil.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

SMON does the clean up...a good article on which you can find at

http://www.jlcomp.demon.co.uk/smon_i.html

HTH

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

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