Deleting datafile from tablespace

I was "experimenting" with adding a new datafile to an existing tablespace and inadvertantly created 2 extra files. Originally the TEMP tablespace only had one datafile, disk:temporary.dbf. Now I also have temporary2.dbf and temporary3.dbf.

What I want to do is to delete these datafiles from the tablespace leaving only the original file. I have issued the "alter database datafile temporary2.dbf offline drop" command which appears to be successful. If I issue a select * from dba_data_files temporary2& 3 both show as available and  viewing datafiles from EM Storage Manager shows them both as offline.

What do I need to do to get rid of these extra files? I tried to take the tablespace offline but that did not do anything as they still show as available and offline. I even renamed one of the files at the OS level and it still shows nder the original name.

I have not restarted the database yet. Since this is a temporary tablespace, would it be simpler to drop the tablespace and then create a new one or would that be more trouble than its worth?

Thanks

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Feb 10 1999 - 15:35:02 CST