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

From: Oracle Apps <oaugdba_at_yahoo.com>
Date: Sat, 4 Nov 2000 06:30:34 -0800 (PST)
Message-Id: <10670.121152@fatcity.com>

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. Received on Sat Nov 04 2000 - 08:30:34 CST