Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 8i temporary tablespace
"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