Re: MISSING datafiles

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Sat, 4 Nov 2006 13:02:57 +0100
Message-ID: <454c8170$0$31585$426a74cc@news.free.fr>

"Ana C. Dent" <anacedent_at_hotmail.com> a écrit dans le message de news: Xns9870D0BD15D55anacedenthotmailcom_at_69.28.173.186...
| V10.2.0.2 Linux
| Long story to which I'll spare everyone the details.
| Database is open, but reports 40 or so missing files.
| How do I convince Oracle to forget it ever knew about these files?
| I am will to forgo data retrival that may have been in them.
| I just want Oracle to pretend they never existed.
|
| Thanks!

drop tablespace ... including contents and datafiles;

Or, if the file is empty:
alter tablespace ... drop datafile ...;

Regards
Michel Cadot Received on Sat Nov 04 2006 - 06:02:57 CST