Re: Moving instance to another host

Wayne Linton <lintonw_at_cadvision.com> wrote:

>Why would you think option C to be faster than A or B? C would have to
>contend with your network.

If you think about it, unless you move the disks, or use tape, you will have to contend with the network.

The question then is, which protocol is more efficient: FTP, NFS, SQL*Net, rcp, etc.

I have had good success with option C in serveral cases. It is especially useful for databases that contain only in-house applications that have up-to-date DDL scripts available.

Create new database. Create tables. Copy data. Create indexes and constraints. Create users. Apply grants.

Okay, that is complex. But it can still be useful if used carefully. I would only try it with an application that I knew well.

Doug Received on Sat May 24 1997 - 00:00:00 CDT