Temp Tablespace

From: <jackwithman_at_my-deja.com>
Date: 2000/06/02
Message-ID: <8h8m2a$rnp$1@nnrp1.deja.com>#1/1

Hello Everyone,

I am very curious of something.
I'm running under oracle 8.1.5 and my temp tablespace (200 M) is always full (99%). As soon as I shut down my database, the temp tablespace is purged but when I bring the database back up it starts growing and in half a day, temp is choking and I have sometimes failures to extend.

Looks like a lot of space is lost.
Is there any way to 'shrink' it, other than bringing the tablespace offline and online right after?

ThanXs for your help.

                                        Jack

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Jun 02 2000 - 00:00:00 CDT