deleted datafile. How do I recover?

Please help!

I have deleted a physical datafile space on Unix box before dropping the tablespace in Oracle. After the fact, when I try to drop Oracle tablespace the Instance crashed. I started the instance in mount mode, try to alter the tablespace offline Oracle tell me db is not open. I then tried to alter db open, I receive error 01157 cannot identify/lock datafile and ora 01110 datafile /oracle/----/----/ datafile"name".
How do I recover Oracle without having to do a backup of the datafile? This datafile has no useful purpose.
Is their a way to recover form this?
THanks
Dev

did you try either of the following at the mount stage --

alter database datafile 3 offline;

or

alter database datafile 3 offline drop;

you can use the datafile name also with the full path

- Rajeev

you need to take the datafile offline, not the tablespace.

- mount the database

- then issue:
alter database datafile
'/disk2/data/datafile_name.dbf' offline;

try that.

- Magnus

Thank Rajeev
When I tried datafile offline the following message occur>
ORA-01145: offline immediate disallowed unless media recovery enabled. Any suggestion how to do this. I am reading up on this. I am a Newbie in Oracle and a have been in MSSQL.
thanks
dev

Magnus. Thank you too! Please read my reply to Rajeev and see how you can assist.
Dev

Thanks fells the off line drop methos work.
cheers
Dave

WHOO-HOOO!