Re: Changing TEMP tablespace from type PERMANENT to type TEMPORARY

From: <dmnwork_at_my-deja.com>
Date: Wed, 07 Feb 2001 11:17:24 GMT
Message-ID: <95ras0$4j9$1@nnrp1.deja.com>

In article <gmZf6.32121$l57.1407636_at_news000.worldonline.dk>, "Gollum" <gollum_nospam_at_worldonline.dk> wrote:
> No need to bring the database down - just ALTER TABLESPACE TEMP
TEMPORARY;
> HTH,
> Gollum

Are you 100% positive this won't effect transactions in progress? (peoples' sorts I suppose, but it's an active production database).

I'd read somewhere that the difference between tablespaces of type PERMANENT and type TEMPORARY is that a tablespace of type TEMPORARY creates one large temporary segment - saving on overhead that would otherwise come from building up and tearing down individual temporary segments. Is this what's actually going on behind the scenes?

Thanks.

Dana

Sent via Deja.com
http://www.deja.com/ Received on Wed Feb 07 2001 - 05:17:24 CST