Re: TEMP Tablespace Question
From: Paul <paul821_at_yahoo.com>
Date: Sat, 25 Oct 2003 23:45:12 GMT
Message-ID: <cWDmb.38672$gA1.12805151_at_news4.srv.hcvlny.cv.net>
Date: Sat, 25 Oct 2003 23:45:12 GMT
Message-ID: <cWDmb.38672$gA1.12805151_at_news4.srv.hcvlny.cv.net>
Anna:
It is a temporary tablespace. I haven't tried the coalesce but I will give it a try.
Thanks.
-- Paul "Anna C. Dent" <anacdent_at_hotmail.com> wrote in message news:BnCmb.84888$Ms2.27047_at_fed1read03...Received on Sun Oct 26 2003 - 01:45:12 CEST
> 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;
>