Re: TEMP tablespace should be temporary or permanent ?

From: <kreitsch_at_my-deja.com>
Date: Thu, 14 Sep 2000 08:07:43 GMT
Message-ID: <8pq104$97$1@nnrp1.deja.com>

you have to switch your temp-TS to temporary. Temporary Segments are not logged to the redo and so the operation ist faster as with permanent ts. you cannot create normal tables in temorary segments. in Oracle 8i you have the possibility to create temporay tables in temporay TS with transaction wide existence of data in a session.

Temp-Segments should have pctincrease by 0. Internally the system uses the Temp-Ts by index-create and sorts. Bye

In article <8ppr45$p0j$1_at_nnrp1.deja.com>, new_dba_at_my-deja.com wrote:
> Hi,
>
> I am wondering whether TEMP tablespace should be temporary or
> permanent. What is the main difference ?
>
> The TEMP tablespace in our production database is permanent. How do I
> decide whether I will benefit by making it temporary.
> Thanks.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Sep 14 2000 - 03:07:43 CDT