Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Upgrade 9.0 to 9.2
"Goran" <goran99_remove_at_yahoo.com> wrote in message
news:brs29i$pho$1_at_fegnews.vip.hr...
>
> <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
The chances that Sybrand has never done an upgrade for a real system are
pretty much nil.
For a 5gb database exp/imp is probably fine. For a 500gb or a 5TB database
exp/imp might be somewhat less efficient than running the upgrade scripts.
http://tinyurl.com/2hefg which is where Sybrand pointed the OP has a pretty
helpful discussion on when you might do what.
-- Niall Litchfield Oracle DBA Audit Commission UKReceived on Thu Dec 18 2003 - 05:41:00 CST