Re: Oracle Upgrade 9.0 to 9.2

From: Frank <fbortel_at_nescape.net>
Date: Thu, 18 Dec 2003 20:15:33 +0100
Message-ID: <brstrl$4t$1@news4.tilbu1.nb.home.nl>

Pete's wrote:

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

Well -as said in this thread- it's clean. You never know what stays behind after an upgrade; Oracle didn't always clean up very well. Or upgrade very well. And what about system tablespace fragmentation if coming from 8i or earlier?
That might be one way to start a myth
("Oh well, you best do a clean install, as my system tablespace data files were three timer bigger after an upgrade, than using imp/exp")

-- 
Merry Christmas and a Happy New Year,
Frank van Bortel

Received on Thu Dec 18 2003 - 13:15:33 CST