Re: TEMP tblspc appear full, how to clean up

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Thu, 16 May 2002 18:07:05 GMT
Message-ID: <3CE3F544.30F062D0@exesolutions.com>

Kenny Yu wrote:

> At one time, O9i complained TEMP tablespace full. I checked to see 99% used.
> I expanded it to 100 mb. It instantly used the 100 mb. The usage mark has
> stayed at 99% ever since. A guy was running a big nested select with
> aggregation. I figure some data is staying there. How do I reclaim the
> space?

If that is the case, and I doubt it, just drop it and recreate it.

(through the database ... not just a physical delete of the file).

Daniel Morgan Received on Thu May 16 2002 - 13:07:05 CDT