Re: Urgrent - Moving instances across machines - Help

On Tue, 07 Oct 1997 00:01:03 -0700, Kluged <kluged_at_ix.netcom.com> wrote:

>are you sure you can just copy the files? have you tried to

This can be slow. It is much quicker to copy the files.

>export/import the database?
>
>

If the files are copied to locations with different paths you will need to recreate your control file (with changed path of course) before you will be able to start the database.

or

Use the alter database rename datafile before you move the files.

Yes, there several steps not mentioned.

Might be worth dumping it to trace before you get rid of the existing instance.

Don't forget the rest of the files - redo logs archive logs etc. Received on Tue Oct 07 1997 - 00:00:00 CDT