This discussion is archived
7 Replies Latest reply: Dec 9, 2012 8:36 AM by 826457 RSS

Upgrade from 9i to 11g with chnges.

826457 Newbie
Currently Being Moderated
Hi All,

Please suggest for best practise.

we habe to upgrade production database which is in 9.2.0.3.0 to 11.2.0.3, has around 180GB of clients data, also lot of changes have to do in terms of Table structure and SP for application upgrade also. Those script is taking 3 hours time.

Taking dump and importing into 11g and running script is taking around 16 Hrs, which is huge in terms of downtime.

What will be the best way to upgrade this with minimum downtime with above scenario and RISK free.

Please suggest ASAP.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points