Re: How does one reclaim temp space?
From: Peter <p.simpkin_at_its.uq.edu.au>
Date: Tue, 20 Nov 2001 09:11:45 +1000
Message-ID: <9tc3mg$rrp$1_at_bunyip.cc.uq.edu.au>
Date: Tue, 20 Nov 2001 09:11:45 +1000
Message-ID: <9tc3mg$rrp$1_at_bunyip.cc.uq.edu.au>
If you are talking about the temporary tablespace, then just alter tablespace and resize it. Every now and then someone might run a really poor query which can blow your temp tablespace out. Manually resizing gets rid of the sometimes excessive size of them.
"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 Tue Nov 20 2001 - 00:11:45 CET