Re: Moving instance to another host

Lassi Salo <Lassi.Salo_at_ntc.nokia.com> wrote:

>Carlos A. Gonzalez wrote:
>> A) Export the whole database in the old host, create the database and
>> corresponding tablespaces in the new host and then do the import.
>>
>> Advantages: Optimize space usage (Compress parameter)
>> Disavantages: Too slow
>> B) FTP the data files to the new host, copy the data files to the
>> corresponding directories, edit the Control File and startup the > instance.
>> Advantages: Faster to do
>> Disavantages: No way to optimize the old database.
>
>I vote for B. Fast & simple. Current wisdom says "multiple extents are
>GOOD for you, when used appropriately". If needed, after B) use A) to
>small set of important tables/indexes.

If both hosts use the same operating system, B should work fine. If they're different, it's still worth a try, but I wouldn't be surprised if it doesn't work.

--
Chuck Hamilton
chuckh_at_dvol.com

If at first you don't succeed, skydiving isn't for you.