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: Oracle 8i temporary tablespace

Re: Oracle 8i temporary tablespace

From: Gerry Sinkiewicz <sinkiege_at_snet.net>
Date: Sun, 07 Nov 2004 19:53:54 GMT
Message-ID: <m3vjd.27235$Qv5.25626@newssvr33.news.prodigy.com>

"Roop" <rupinder99_at_hotmail.com> wrote in message news:jtBid.19333$v03.316147_at_wagner.videotron.net...
> Hello
> I want to recreate the temporary tablespace in ORACLE 8i and I
am
> doing the following steps:
>
> 1. STARTUP (OPEN MODE)
>
> 2. create tablespace temp_data1
> datafile 'temp_data1.dbf' size 30m autoextend on next 10M
> default storage (
> initial 100k
> next 100k
> minextents 1
> maxextents unlimited
> PCTINCREASE 20)
> online
> temporary;
>
> 3. DROP TABLESPACE TEMP_DATA INCLUDING CONTENTS; //DROPS THE OLD
TEMPORARY
> TABLESPACE
>
> 4. ALTER USER SYS TEMPORARY TABLESPACE TEMP_DATA2; //ASSIGN
USERS
> NEW TEMPORARY TABLESPACE
> 5. ALTER USER SYSTEM TEMPORARY TABLESPACE TEMP_DATA2;
>
>
> Are these steps ok (how is default temporary tablespace assigned in 8i)
and
> am i missing any of the steps.
>
> Thank you in advance
>
>
>
>

Have you considered using a create temporary tablespace tempfile ..... configuration.

We have found using temporary tablespaces with tempfiles as opposed to tablespaces named temp
to be beneficial in our 8i instances. Received on Sun Nov 07 2004 - 13:53:54 CST

Original text of this message

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