RE: Database Migration and Upgrade across Servers ( from Solaris to HP)

From: Allen, Brandon <>
Date: Thu, 31 Jul 2008 09:39:50 -0700
Message-ID: <04DDF147ED3A0D42B48A48A18D574C450CCAD552@NT15.oneneck.corp>

My preference is to always use exp/imp unless there is a good reason not to do so, e.g. uptime requirements. Export followed by import into a brand new database gives you a nice clean data dictionary with that fresh new smell, plus you get a full defrag of all your segments as a bonus (not that I'm a proponent of regular segment rebuilds) and can take the opportunity to change your tablespace layout or configurations if desired. There are at least a few serious bugs that can hit after in-place upgrades (not if you use exp/imp) - check Metalink for details. The ones I'm thinking about are specific to databases that were upgraded from 8i to 10g, IIRC. Since you're on 10g, expdp/impdp could be worth considering too, but from what little testing I've done with datapump, it was much slower and more complicated than good 'ol exp/imp.  



Received on Thu Jul 31 2008 - 11:39:50 CDT

Original text of this message