From kirtikumar_deshpande@yahoo.com Thu, 05 Jun 2003 02:07:36 -0700 From: Kirtikumar Deshpande Date: Thu, 05 Jun 2003 02:07:36 -0700 Subject: RE: Good technical documents/references on tuning restores Message-ID: MIME-Version: 1.0 Content-Type: text/plain Paula, Was the tablespace read-only? Those weired MISSING... names refer to data files in those tablspaces. Do you have a controlfile trace? Look in there to see what is what.. Here is what I see in the CF trace for my read-only tablespace: # Files in read-only tablespaces are now named. ALTER DATABASE RENAME FILE 'MISSING00002' TO '/u07/oradata/DBCT/test_01.dbf'; # Online the files in read-only tablespaces. ALTER TABLESPACE "TEST" ONLINE; # No tempfile entries found to add. # HTH, - Kirti --- Henry Poras <[EMAIL PROTECTED]> wrote: > RE: Good technical documents/references on tuning restoresPaula, > > IIRC 'MISSING' means it is in the data dictionary, but not the control file. > I've gotten that before, but haven't played that game in a while. You might > be able to 'DROP' them, but I'm not sure. Check that first on a mini-test > system. > > Henry > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of > [EMAIL PROTECTED] > Sent: Tuesday, June 03, 2003 11:05 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Good technical documents/references on tuning restores > > > Okay, > > Database open and I wanted to not restore and not reference certain index > and materia. view datafiles. Now the datafiles show up with weird > MISSING...... names. How do I clean this up? > > Thanks, > paula > __________________________________ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).