Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> UNDO tablespace issue- the dropped datfaile still shows in v$recover_file
Hi All,
I dropped the datafile undotbs1.dbf that blong to undo tablespace undotbs1 and added another datafile undotbs2.dbf . But now I see that v$recover_file shows undotbs1.df as a file to recover.
so when I try to do this. it complains
SQL> alter tablespace undotbs1 drop datafile '/lob1/undotbs01.dbf';
alter tablespace undotbs1 drop datafile '/lob1/undotbs01.dbf'
*
ERROR at line 1:
ORA-03263: cannot drop the first file of tablespace UNDOTBS1
Can someone please suggest how do I synch it .
thanks in advance
Prasad
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Sep 10 2007 - 14:48:24 CDT