Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: UNDO tablespace issue- the dropped datfaile still shows in v$recover_file
In Oracle, you can NOT and should NEVER drop a datafile from a a
tablespace. Oracle, however, provided a single SQL interface to doing so
ONLY in anticipation to dropping the entire tablespace. You only choice
is to follow what's mentioned in the other 2 replies. Even with 10gR2,
the DATAFILE must be blank.
Thank you
Fred Habash, Lead Oracle DBA (OCP 8i,9i) Oracle Team Portal http://spc-00sv0d03e3.spc.supc.com/ddcports/oracle/
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 12 2007 - 10:51:33 CDT