Re: Oracle Upgrade 9.0 to 9.2

From: Goran <goran99_remove_at_yahoo.com>
Date: Thu, 18 Dec 2003 11:39:39 +0100
Message-ID: <brs05d$n32$1@fegnews.vip.hr>

"John Wood" <jwood_at_hotmail.com> wrote in message news:8IaEb.102405$bC.38876_at_clgrps13...
> I am running Oracle 9.0.1.4 on Window 2000 platform. I plan to upgrade
the
> Oracle to 9.2.
> I was told that in order to have clean upgrade, it is better to do a full
> export. Then delete the datafile in the older version, run the upgrade,
> create the needed tablespace, then do the import.
>
> This way we will not see any odd problem.
>
> Please advise if this is true.
>
> Thanks.
>

The "cleanest" method is to perform full export, install 9.2.0.x software preferably to another ORACLE_HOME, then create a new 9.2.0.x database, create tablespaces etc, then perform full import. Oracle claims that upgrade utility works fine, but this is not certain.

Regards... Received on Thu Dec 18 2003 - 04:39:39 CST