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.

The best advise you can get is not from useless hearsay like the one you got, but by reading the upgrade manual.

Sybrand Bakker
Senior Oracle DBA Received on Thu Dec 18 2003 - 04:39:39 CST