Re: Oracle Upgrade 9.0 to 9.2

"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.
>
> Jw.

Don't know why they told you that. I'm not running win2k, but, on aix 4.3.3 I upgraded a 9.0.1.3 instance to 9.2.0.4 without any problems. I don't see the added value in doing an export, deleting the database, creating a new 9.2 instance and then doing an import, seems like a lot of extra work. Why not test the upgrade process on a test instance?

HTH,
Pete's

The opinions I may have stated here are mine and not that of my employer. Use any advice given AT YOUR OWN RISK. Received on Thu Dec 18 2003 - 07:47:17 CST