Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How does one reclaim temp space?

Re: How does one reclaim temp space?

From: Cong Tang <Cong.Tang_at_ctbto.org>
Date: Tue, 20 Nov 2001 09:59:25 +0100
Message-ID: <20011120.085827.986770@CTBTO.ORG>


Hello,

You may want to try the following commands:

alter tablespace TEMP permanent;
alter tablespace TEMP temporary;

Regards,
Cong
Mendoza Family wrote:
>
> 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 - 02:59:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US