This content has been marked as final. Show 2 replies
I doubt if you can directly upgrade to 11g. you probably need to upgrade your 8i db to 9i or 10g then you need to upgrade to 11g.
ref : http://www.oracle.com/technetwork/database/upgrade/best-practices-for-upgrading-11gr2-174946.pdf --[Page 45]
one of the option you can consider is : install 11g software and create new 11g database then exp your 8i database and import it into your 11g database.
Ref : https://blogs.oracle.com/UPGRADE/entry/behaviour_changes_from_oracle_8i
Behaviour Changes between Oracle 8i and Oracle 11.2
Please note: This is not a 100% complete summary but it will give you a rough overview about parameter and dictionary changes from release to release plus a summary of documented behaviour changes.
Edited by: Veeresh.S on Oct 3, 2012 10:27 PM
Our Database Administrators will be taken care regarding up gradation. I'm an PL SQL dev.
I need suggestions ( Dev. point of view) what are things we need to taken care before and after up-gradation ?