Re: Migrate from Oracle 9i to 10g on new Hardware

From: <madhusreeram_at_gmail.com>
Date: Wed, 11 Mar 2009 13:07:14 -0700 (PDT)
Message-ID: <6a141c4c-5d71-4119-82bc-5cc04e13fe64_at_z9g2000yqi.googlegroups.com>



On Mar 11, 12:01 pm, Brian Baumann <ferretwo..._at_gmail.com> wrote:
> We currently have Oracle 9i setup for our production environment. We
> would like to install 10g on new hardware and bring in the data from
> our 9i setup.
>
> Most of the documentation refers to either upgrading in place or just
> fresh installs.
>
> Can anyone point me in the right direction?

Refer to Oracle Database Upgrade Guide. You can use export/import for upgrade, or use Database Upgrade assistant or manual upgrade using scripts.
If you choose a non-export method, one method is:

- install 10g on existing h/w
- upgrade
- install 10g on new h/w
-physically copy the files from existing h/w

h/w => hardware. Received on Wed Mar 11 2009 - 15:07:14 CDT

Original text of this message