Re: TEMP tablespace should be temporary or permanent ?

Also,if you are running Oracle 8i, make it a locally managed tablespace.

HTH,
Brian

kreitsch_at_my-deja.com wrote:
>
> 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.
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================