Re: Temp Tablespace Full

On Sun, 25 Dec 2005, Michael42 wrote:

> In Oracle 9i I ran an operation that gathered statistics. It ran for
> several hours and I ended up having to break out of it. The result is
> that my TEMP tablespace is full (OEM shows it as full). Other than
> bouncing the database how can I have the TEMP tablespace clean itself up?

I read on ixora.com.au sometime ago that "alter tablespace temp default storage (pctincrease 0)" will cause Oracle to drop the sort segment. This works very well under Oracle 7; under LMTs your mileage may vary.

   / Charles J. Fisher   |  /* You are not expected to understand this */    /
  /  cfisher_at_rhadmin.org |    -- Sixth Edition Unix Source Code Comment     /
 /   http://rhadmin.org  |                                                 /
---------------------------------------------------------------------------