If you added the datafile to the same tablespace then for all versions
of Oracle up through 10.2 once you drop a datafile from a tablespace you
have to either recover or drop the tablespace.
You should create a new undo tablespace
Make it the current undo tablespace
Drop the original undo tablespace
If you added a new undo tablespace then just the second two items apply.
-- Mark D Powell --
Phone (313) 592-5148
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Prasad
Sent: Monday, September 10, 2007 3:48 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: 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
