Datafile Recovery

[Irfkhan]

I have a production database with oracle 7.2 on Unix

I added one datafile and by mistake it got added to worng tablespace and there is no option to drop a datafile

One thing is that its completely empty now how do i go about removing it itried an it went in recover stage means

V$datafile shows recover as a status for this datafile

I dont need this datafile at all

How do i go about it

Regards
Irfan Khan

[tamilselvan]

Better resize the data file instead of dropping because Oracle does not allow to drop one data file if the tablespace has more than one data file. Or you have to drop the tablespace.