TEMP tablespace
From: airmax <airmax.2c9ghz_at_no-mx.forums.yourdomain.com.au>
Date: Wed, 9 Aug 2006 01:25:24 -0500
Message-ID: <airmax.2c9ghz_at_no-mx.forums.yourdomain.com.au>
Date: Wed, 9 Aug 2006 01:25:24 -0500
Message-ID: <airmax.2c9ghz_at_no-mx.forums.yourdomain.com.au>
Hello DBA’s
I have a problem with my TEMP tablespace. It’s 1 GB and its full. Shouldn’t be empty? When the tablespace is full i have to restart the database in order clean up the tablespace, but this is not a solution!!! I don’t want to extend it becuase it will be full again. In my previous job the table space was 800MB and it was always empty.
What I should do?
Regards
Panos
-- airmax ------------------------------------------------------------------------ airmax's Profile: http://www.dbtalk.net/m627 View this thread: http://www.dbtalk.net/t324583Received on Wed Aug 09 2006 - 08:25:24 CEST