Re: changing location of datafiles.

From: Bill Bearden <bbearden_at_bcl.net>
Date: 28 May 98 11:08:45 GMT
Message-ID: <01bd8a29$658a5a20$91bccecf@bbearden>

Sure.

Restore the files to the locations you want them. Then open the database to the 'mount' state. Next, do a series of alter database rename file 'a' to 'b'; commands.

I am assuming that you already have Oracle up and running on the new machine. You may have to change your /etc/oratab and your tnsnames.ora file and a few other things because you moved to a new machine.

Bill Bearden
Consultant

Mike Mountjoy <michael_at_london.virgin.net> wrote in article <6kh1tl$58e$1_at_nclient1-gui.server.virgin.net>...

<<stuff deleted>>

> Is there a way of doing this without first restoring the datafiles to
the
> orginal
> machine and doing a export/import to the new machine.
>
>
> Regrds,
> Mike
Received on Thu May 28 1998 - 06:08:45 CDT