Re: 10g upgrade survey

On 3/5/07, Jeremiah Wilton <jeremiah@xxxxxxxxxxx> wrote:


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?



I entirely agree, though you said it better. I'd also like to be really
convinced that the exp/imp route also includes the necessary scripts to
check for all the little things that might bite you - like characterset
changes, changed and deprecated parameters etc. I'd also hazard a guess that
people with multi-terabyte databases don't favour exp/imp! IMO dbua - at
least in 9.2 and 10.2 (javen't seen any others) does a great job at ensuring
you upgrade properly. exp/imp probably does the worst job.

I can sympathize though with people who combine several upgrades
simultaneously - for me that's a risk assessment for the business, "yes you
get lower outage, but the cost is support and troubleshooting post the
upgrade: do you want to take the risk we might take longer determining any
fault or not?"

--
Niall Litchfield
Oracle DBA
http://www.orawin.info

Other related posts: