Re: missing datafile

From: Uldis Pavuls <U.Pavuls_at_konts.lv>
Date: 1997/07/30
Message-ID: <01bc9cfd$590cc7c0$4d2a949f@uldis.konts.lv>#1/1

Hi,
if you are sure you *do not* need this file (e.i. there haven't been any "live" object placed there) you may try to get out via recreation of controlfiles ( see docs for details ). You can do it for reason to save all possible, too.
Wbw,
Uldis
U.Pavuls_at_konts.lv

Shuang Li <sli1_at_cs.umbc.edu> wrote in article <33DAC4C6.41A4_at_cs.umbc.edu>...
> Hi,
> While trying to put "USERS" tablespace back online, I received the
> following error messages:
>
> ORA-01157: cannot identify data file 8 - file not found
> ORA-01110: data file 8: '/u01/oradata/csee/users04.dbf'
>
> I then check if /u01/oradata/csee/users04.dbf exists or not by looking
> into the directory /u01/oradata/csee/ and can't find file 'users04.dbf'
> either. It is greatly appreciated if anyone kindly suggests how to fix
> this problem.
>
Received on Wed Jul 30 1997 - 00:00:00 CDT