I want to delete 45 datafiles from my database. I have offline dropped
them, and then re-created the controlfiles using an edited copy of the
"backup controlfile to trace" script. When I run
'select file#, name, status from v$datafile;'
I see the files are now "MISSING" and have a status of RECOVER. So I
guess that they are still in the data dictionary and missing from the
How can I cleanly remove these files?
Sent via Deja.com http://www.deja.com/
Before you buy.