Re: ORA-1157 Datafile Problem

From: Pat <smartinp_at_iconz.co.nz>
Date: 1998/01/08
Message-ID: <6926hv$f9u$1@news.iconz.co.nz>#1/1

Use Server Manager:

Connect Internal
Startup NoMount
DROP TABLESPACE yourtablespacename INCLUDING CONTENTS ALTER DATABASE OPEN You can't just recreate a file of the same name as the original contains required control information which is verified by Oracle e.g. it's checkpoint number. . .

Pat Martin.

Ken Hinerman - Erols wrote in message <34B4580C.4E4AD729_at_saec.com>...
>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 Thu Jan 08 1998 - 00:00:00 CST