Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Upgrade 9.0 to 9.2
<sybrandb_at_yahoo.com> wrote in message
news:a1d154f4.0312180239.5161ac97_at_posting.google.com...
> "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
It seems that you either never performed an upgrade of a real database, or have been *very* lucky not to encounter any problems during or after the upgrade...
Regards,
Goran Dokmanovic
Senior Database Administrator
VIPNet d.o.o
Zagreb, Croatia
Received on Thu Dec 18 2003 - 05:16:02 CST