Re: Deleted Database File - Oracle won't start

Try "alter database datafile 'full pathname' offline drop;"

Karel
Jeffrey Lilienstein wrote:
>
> Try "alter database create datafile ....." if you do not have a backup.
> This will allow the instance to start and open.
>
> Jeff
> --
>
> Important:
> Delete the "REMOVE-THIS" from the e-mail address before replying.
>
> Frederic Perez wrote:
> >
> > Hi all,
> >
> > A database file has been deleted, and now oracle does no longer want
> > to start.. I have these messages:
> >
> > ORA-01157: cannot identify data file 23 - file not found
> > ORA-01110: data file 23: '/bmd/db/bmd_data.dbf'
> >
> > The problem is that I don't know how to 'remove' this stuff now !
> > The best way could be to create a new data file... but how can I set the
> > data file number ??
> >
> > Regards,
> >
> > Frederic
  Received on Mon Nov 24 1997 - 00:00:00 CET