Re: Datafile deleted while instance down!

From svrmgrl, connected internal, or as sysdba: startup mount
alter database datafile 'your fully qualified deleted file name here' offline drop;
alter database open;

"David A. Ceretti" wrote:

> I had a datafile get deleted while the instance was down, and am
> subsequently unable to re-start the instance. The datafile wasn't
> backed-up. Does anybody have any idea how I can get my instance back? The
> contents of this datafile don't matter (it was used for indexes), but the
> rest of my DB does.

--
Gtrz,

Frank van Bortel