Re: ***8i Temporary Tablespace -Tempfile * Locally Managed

We're running 8.1.6 and 8.1.7 on Sun Sparc/Solaris.

Not observing this. When we create the tablespace the data file space immediately shows up. Since Oracle is not formatting the files, the create happens very fast. ----- Original Message -----
From: Arun J Muthalaly <arunjacob_at_0racledba.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Friday, November 03, 2000 12:30 PM Subject: ***8i Temporary Tablespace -Tempfile * Locally Managed

> Hi,
>
> I cteated a Temporary Tablespace in 8.1.6.2 with the followinf statement.
>
> CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE
> '/data/YIPEEIA/u08/p03_ss02_d06_2g_21' SIZE 2000M
> EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10M
>
> and subsequently added more datafiles
>
> ALTER TABLESPACE TEMP1 add TEMPFILE
> '/data/YIPEEIA/u08/p03_ss02_d06_2g_25' SIZE 2000M
> '/data/YIPEEIA/u08/p03_ss02_d06_2g_26' SIZE 2000M
> '/data/YIPEEIA/u08/p03_ss02_d06_2g_27' SIZE 2000M
> '/data/YIPEEIA/u08/p03_ss02_d06_2g_28' SIZE 2000M
> '/data/YIPEEIA/u08/p03_ss02_d06_2g_29' SIZE 2000M
> '/data/YIPEEIA/u08/p03_ss02_d06_2g_10' SIZE 2000M
> /
>
> When i query the datadictionary tables i get
>
> SQL> select FILE_NAME from dba_data_files where TABLESPACE_NAME = 'TEMP1';
> no rows selected
>
> and
>
> select TABLESPACE_NAME,EXTENT_MANAGEMENT,STATUS,CONTENTS from dba_tablespaces;
>
> SAM_T_SPLY_TYPE_T LOCAL ONLINE PERMANENT
> SAM_T_SPLY_TYPE_I LOCAL ONLINE PERMANENT
> TEMP1 LOCAL ONLINE TEMPORARY
>
> which i think is as per the Docs
>
> But the Strange part is that the datafiles doesnt consume any space in the filesystem unless i do some activity (Index builds) in
the TEMP1 tablespace.
>
> This Can become a problem if at a time of Temporary tablespace inactivity , other DBA's may try to add datafiles to other
Tablespaces since there is Free (virtual) space available.
>
> Please advise....
>
>
> Cheers
>
> Arun Jacob M
>
>
>
>
>
>
>
>
> _____________________________________________________________
> Be someone_at_0racledba.com - get your free mail from Oriole Corporation
> http://www.oriolecorp.com - Performance tools for Oracle DBAs
>
> Get email for your site ---> http://www.everyone.net
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Arun J Muthalaly
> INET: arunjacob_at_0racledba.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Fri Nov 03 2000 - 15:00:50 CST