Re: Database move

From the name it is looking for the system tablespace. Without the system tablespace, location of the datadictionary you can't start the database.
Does that file exist?
Where is it?
If it is in a different location, move it to the location of the error message.
If you don't have it, you'r out of luck.

Hth,

Sybrand Bakker, Oracle DBA

Catherine Sylvester <csylvester_at_bbo.on.ca> wrote in message news:38D6432A.4BE42337_at_bbo.on.ca...
> As per a message above I moved the Oracle database from one server to
> another. I have been able to get the database running, however it
> cannot find the data file. I receive the following errors:
>
> 01157 cannot identify data file 1 file not found
>
> 01110 data file 1 programs:oranw732\database\syslorcl.ora
>
> is there a way to start the database and tell it where to look for the
> data file. I am assuming that is what it is looking for. The data??
>
> Cathy
>
Received on Mon Mar 20 2000 - 09:58:58 CST