RE: 8.1.7.4 upgrade - 10g or 11
Date: Wed, 9 Apr 2008 10:27:58 -0700
Message-ID: <04DDF147ED3A0D42B48A48A18D574C450B2DC4A5@NT15.oneneck.corp>
Yes, 8.1.7.4 can go directly to 10g, not sure about 11g, but either way,
I'd recommend you read the migration guide, all release notes, alerts,
etc. to verify this and many other details before starting such a
project. You might also find this list of common CBO issues with 8i-10g
upgrades helpful:
http://www.freelists.org/archives/oracle-l/07-2006/msg00516.html
I'd recommend you create a new database and migrate via exp/imp rather than doing an in-place upgrade. There is at least one nasty bug with upgrades to 10.2.0.3 and last time I checked the only solution was to use exp/imp or just stay on 10.2.0.2 instead, although it may be fixed in 10.2.0.4 now.
Regards,
Brandon
Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Apr 09 2008 - 12:27:58 CDT