Re: temp tablespace

senthil wrote:
>
> hi there,
> my temp tablespace holds 1gb of data which is not freeing up. i am
> unable to restart my database since its on production site. is there
> any command clean the temp tablespace.
> any help is appreciated.
> thanks
> -senthil.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

If its type is TEMPORARY (select * from dba_tablespaces) then its meant to stay full, since these can be re-used by either sort operations.

Some earlier versions of Oracle didn't "mark" these areas free for re-use which may be the cause of your problems...

Options:

• set it to permanent and then back to temporary. This should get SMON to come along at empty it out
• drop and recreate it.

HTH

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

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