Re: temp tablespace

From: Jaap W. van Dijk <j.w.vandijk_at_kpn.com>
Date: 8 Sep 2000 15:56:42 GMT
Message-ID: <01c019ad$6207aa40$942a15ac@HKTGN0003049994>

Since Oracle 7.1 (3?) it is possible to create tablespaces of type TEMPORARY. In this tablespace you can only hold temporary segments, which are not removed, but instead an administration is kept which segment is assigned to which session (see view V$SORT__SEGMENT). This is because it is faster to keep an administration then to create and remove segments all the time.

So there is no need to 'clean' your temp tablespace.

Jaap.

senthil <rsenthilkumar_at_my-deja.com> schreef in artikel <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 Fri Sep 08 2000 - 10:56:42 CDT