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

Hi Arun,

 Have you checked in DBA_TEMP_FILES view?  May be you need to 'union' these views now to see all the 'data' files.

 HTH..

• Kirti Deshpande http://www.superpages.com

> -----Original Message-----
> From: Arun J Muthalaly [SMTP:arunjacob_at_0racledba.com]
> Sent: Friday, November 03, 2000 12:30 PM
> To: Multiple recipients of list ORACLE-L
> 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';
Received on Fri Nov 03 2000 - 14:12:47 CST