Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-1157 Datafile Problem

Re: ORA-1157 Datafile Problem

From: John P. Higgins <jh33378nospam_at_deere.com>
Date: 1998/01/07
Message-ID: <34B4669E.7939@deere.com>#1/1

issue startup mount
alter database datafile _____ offline drop alter database open
alter tablespace __________ offline
drop tablespace __________

Ken Hinerman - Erols wrote:
>
> Need Help ASAP. My database just went down because it says it can't find
> a datafile. I checked and the datafile is indeed gone. I tried
> recreating a file using mkfile -v 50M filename.dbf and bringing the
> database back up. This however does not work. Can anyone offer any
> suggestions to bring the database back up I don't care about the data in
> the tablespace and can be trashed for all I care. But I do need the data
> in the other tablespaces.
>
> Thank you
> Ken Hinerman
Received on Wed Jan 07 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US