Re: missing datafile

From: Gary Assa <gsa_at_panix.com>
Date: 1997/07/28
Message-ID: <5ri7v3$fnp@panix.com>#1/1

You are going to have to find this file. Does it reside somewhere else? Why would your database want that file if it's not there. It sounds like someone dleeted it while the database was shutdown.

>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.

-- 
                     ------------------------------------
If you have a condom and sunscreen SPF 15 or greater, than it's safe to look at
                     http://www.panix.com/~gsa/index.html

Received on Mon Jul 28 1997 - 00:00:00 CDT