Re: Database move

From: Mike Streeton <mikestreeton_at_crazydiamondcorp.demon.co.uk>
Date: Mon, 20 Mar 2000 16:07:39 -0000
Message-ID: <953568704.12461.0.nnrp-14.c2ded5f0@news.demon.co.uk>

Cathy,

You will have to start the database up in mount exclusive then use alter database to rename the datafiles to the new location on machine you have transferred them to. I am assuming that you have not restored the files to the exact same locations on the new machine from the old.

Hope this helps

Mike

"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 - 10:07:39 CST