From: paul821@yahoo.com   
      
   Anna:   
      
       It is a temporary tablespace. I haven't tried the coalesce but I will   
   give it a try.   
      
       Thanks.   
   --   
   Paul   
   "Anna C. Dent"  wrote in message   
   news:BnCmb.84888$Ms2.27047@fed1read03...   
   > 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)