RE: UNDO tablespace issue- the dropped datfaile still shows in v$recover

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Tue, 11 Sep 2007 12:50:52 -0400
Message-ID: <D1DC33E67722D54A93F05F702C99E2A901503829@usahm208.amer.corp.eds.com>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Prasad

	Sent: Monday, September 10, 2007 3:48 PM
	To: oracle-l_at_freelists.org
	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

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Sep 11 2007 - 11:50:52 CDT

RE: UNDO tablespace issue- the dropped datfaile still shows in v$recover_file