Re: From ORA 7.3 to ORA 8.05

From: Frank van Bortel <f.van.bortel_at_vnl.nl>
Date: Fri, 12 Nov 1999 10:31:34 -0800
Message-ID: <382C5D06.92F9E5AA@vnl.nl>

Billy Collins wrote:

> HI
>
> I have a simple question: we have finally decided its time to migrate
> to the new db, and now are figuring out whats the best, most
> recommended way of doing it?
>
> 1. Copy the old data to a temp table, and then, through SQL, insert
> into the new database.
>

Means having 2 versions running at one time. Can be done, but uses more than twice the memory, file space you now use on 7.3 Can you afford that?

>
> 2. Use some sort of migration utility..does Oracle have one of its own,
> and if yes, what could be possible drawbacks of this method?
>

Yes. Check out the platform specific installation guide off technet. Usually called mig.

>
> 3. <Insert any other idea here>
>

One other appraoch mentioned in the installation guide is to export-import

>
> I would appreciate any and all experiences/suggestions!
>
> Thanks a ton in advance..
>
> Regards
> Billy
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

--
Met vriendelijke groet/kind regards,

Frank van Bortel
Technical consultant Oracle

Work:                                Home:
----------------------------------   ----------------------------
Inter Access V&L                     Hunzestraat 4
Palatijn 3, 7521 PN Enschede         7555 WB Hengelo
PoBox 545, 7500 AM Enschede          (31)074-2425046

053-4341500 Received on Fri Nov 12 1999 - 12:31:34 CST