Re: 10g upgrade survey

I don't agree with the majority of respondents to the list who like to use the exp/imp method to upgrade their databases. Why, in the absence of real necessity, would one completely unload and reload their data, rather than just running the upgrade script? Most of the reasons cited have nothing to do with an upgrade, and should really be regarded as separate issues. Trying to throw in other tasks alongside an upgrade is just a recipe for instability.

Among the reasons cited were:

• Migrating to another O/S: Why should this be done at the same time as the upgrade? Why add additional complexity to an already potentially destabilizing event?
• Moving to LMT: What is wrong with migrating to LMTs? It can be done bit by bit in shorter outage windows an with much lower stakes.
• Importing results in a "cleaner dictionary": I guess I would need both the meaning and benefit of that explained to me.
• There was a problem with HWM of DMTs caused by an application after a previous upgrade of a different version: Why not just solve this problem? Why would this apply to the current situation?
• The data dictionary could not be upgraded due to corruption: This is the only good reason I could find in all the responses. Still, support should have been able to help you make your DD upgradeable. What if the DB had been 10T?

I guess I am puzzled by the eagerness so many have for unloading and completely reloading their data, when all they really need to do is run Oracle's upgrade script. I am equally puzzled by the desire to bundle up major changes like an upgrade and an O/S change or DMT to LMT. Why not do complicated things one at a time? How will you tell which thing you did caused the horrible bug you find yourself battling after the outage?

Regards,

Jeremiah Wilton
ORA-600 Consulting
http://www.ora-600.net

> Dennis Williams wrote:
>
> If you've upgraded more than one database to 10g, please let me know
> what method you chose:
>
> 1. dbua
> 2. Manual upgrade
> 3. Created a 10g database and migrated the data.
>
>

--
http://www.freelists.org/webpage/oracle-l