Re: How does one reclaim temp space?

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Tue, 20 Nov 2001 05:22:31 +1100
Message-ID: <3bf94d56$0$13481$afc38c87@news.optusnet.com.au>

It's not supposed to shrink. That's not what TEMP does. Extents created by large sorts are not relinquished, but are marked as being re-useable by subsequent sorts that need the space. This crops up with a fair degree of regularity on the group.

However, if you are desperate for the space back, there are things you can do: shutdown and startup springs to mind. Also, take the tablespace offline and then online. Or, depending on what sort of temporary tablespace it is, alter it to be permanent and then alter it back again to temporary.

Regards
HJR

--
Resources for Oracle: http://www.hjrdba.com
===============================


"Mendoza Family" <NetScans_at_ix.netcom.com> wrote in message
news:3BF94627.71601A7B_at_ix.netcom.com...


> I have temp space that is not shrinking. Is there a way to reclaim the

> temp space in the same manner as the shrink for the rollbacks?

>

> Thanks for any help given,

> Moises

Received on Mon Nov 19 2001 - 12:22:31 CST