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

text/x-vcard attachment: Card for Cong Tang

Received on Tue Nov 20 2001 - 02:59:25 CST

This message: [ Message body ]
Next message: Se.d.a.: "Rollback segment too small"
Previous message: Jesper S. Knudsen: "How to create computed field/column in a table"
In reply to: Mendoza Family: "How does one reclaim temp space?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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