You can't remove a datafile from a tablespace. Since this is the TEMP
tablespace, I would drop it and recreate it.
--
Terry Dykstra (TeamPS)
Canadian Forest Oil Ltd.
ehald_at_my-dejanews.com wrote in message <79su25$9ro$1_at_nnrp1.dejanews.com>...
>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 - 18:02:46 CST
