Re: temp tablespace

Well if it is not freeing, why not find the offensive sql and get rid of that.

In article <8paq7o$km8$1_at_nnrp1.deja.com>,   senthil <rsenthilkumar_at_my-deja.com> 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.
>

--
Ender Wiggin


Sent via Deja.com http://www.deja.com/
Before you buy.