Re: temp tablespace

From: Dave Leather <david.leather_at_energis-squared.com>
Date: Tue, 19 Sep 2000 13:18:33 +0100
Message-ID: <8q7lqv$qvc$1@newsg3.svr.pol.co.uk>

If the tablespace is not permenant i.e it is definatly temp the the data is in a segment of type temp, this is intended design. It doesn't release the storage to avoid the overhead of re-allocating it later. It's not a problem.

"senthil" <rsenthilkumar_at_my-deja.com> wrote in message news:8paq7o$km8$1_at_nnrp1.deja.com...
> 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.
Received on Tue Sep 19 2000 - 07:18:33 CDT