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 Mon Nov 19 2001 - 17:11:45 CST
