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?
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.