From: anacdent@hotmail.com   
      
   Paul wrote:   
      
   > I have several databases running on Solaris 2.8 and Oracle 8.1.7.4.  I   
   > only have this problem with one of them.   
   >   
   > The temp tablespace always fills up and Oracle does not clear it out.   
   > If I expand the size of it, it still fills up.  Even if all processes   
   > are finished, Oracle does not clear it out.  Then I have programs fail   
   > with the "Unable to extend" error on the temp tablespace.   
   >   
   > We either have to bounce the DB, or drop and re-build the temp   
   > tablespace when this happens.   
   >   
   > Does anyone out there have any ideas why this happens in only one   
   > application that I support, and how to fix it ?   
   >   
   > Thank you.   
   > --   
   > Paul L.   
      
   EXACTLY  which type of "temp" tablespace do you have;   
   permanent or temporary?   
      
   Have you tried ?   
   ALTER TABLESPACE TEMP COALESCE;   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)