RE: Datafile "missing"

From: James Bullard <jbullard_at_onvia.com>
Date: Wed, 13 Dec 2000 07:32:12 -0800
Message-Id: <10709.124438@fatcity.com>

Once you have offline dropped the datafile, the data dictionary is = updated
and assigns a 'MISSINGn' to the file name. So at this point you still = have
the tablespace and the datafiles according to Oracle. The only way I = have
been able to clear the data dictionary is by dropping the tablespace altogether. That way you can recreate the tablespace and datafiles = after
the tablespace is dropped.=20

HTH,
James=20

-----Original Message-----
From: Daniel Campomanes [mailto:dcampoma_at_telecompersonal.com.ar] Sent: Wednesday, December 13, 2000 7:16 AM To: Multiple recipients of list ORACLE-L Subject: Datafile "missing"

Hi Lists;
Our issue:
A disk crashed in a database, that is a warehouse ( is in NOARCHIVE = mode),
in this disk we had only 6 datafiles that have only one table with old information. We did:
- Startup mount only , and ...

• alter database datafile 'filename' offline drop in each datafile. Now, the database is up and OK, but the "drop" didn=B4t work. The datafiles remains in the dictionary and the space is "allocated"; I means, for oracle, the tablespace have 120 GB , but 20 GB (the crashed disk) doesn=B4t exist. We want to use the same name for the news datafiles, but we can=B4t. We want to drop the ghosts datafiles and put free the wrong allocated space . Oracle support said: you have to re-create the tablespace and then, create the datafiles again ... This job is very complicated (remember, 120 GB and without free space in others disks) How can I drop the datafiles easily? SO: Digital Alpha 4d , Oracle 8.0.5.1.1

Thanks in advance ...

--=20

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--=20

Author: Daniel Campomanes
  INET: dcampoma_at_telecompersonal.com.ar

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).. Received on Wed Dec 13 2000 - 09:32:12 CST