From: airmax.2c9ghz@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/t324583   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)