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

Nope. They are in v$tempfile

Oracle Apps wrote:

> How about v$datafiles??
>
> --- "Deshpande, Kirti" <kirti.deshpande_at_verizon.com>
> wrote:
> > 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';
> > > no rows selected
> > >
> > > and
> > >
> > >
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: Deshpande, Kirti
> > INET: kirti.deshpande_at_verizon.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
> > also send the HELP command for other information
> > (like subscribing).
>
> __________________________________________________
> Do You Yahoo!?
> Thousands of Stores. Millions of Products. All in one Place.
> http://shopping.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Oracle Apps
> INET: oaugdba_at_yahoo.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 Tue Nov 07 2000 - 07:04:23 CST