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!

"Ana C. Dent" <anacedent (AT) hotmail (DOT) com> a écrit dans le message de news: Xns9870D0BD15D55anacedenthotmailcom (AT) 69 (DOT) 28.173.186...
drop tablespace ... including contents and datafiles;

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

Regards
Michel Cadot

Michel Cadot schreef:
The automagical job will keep on trying to collect stats on object in
the dropped tablespace, because it will not have these entries removed
from internal tables.
It's a bug (4707226)... Also, see:
http://vanbortel.blogspot.com/2006/0...ora-20000.html

--
Regards,
Frank van Bortel

Top-posting is one way to shut me up...