7 Replies Latest reply: Dec 9, 2012 10:36 AM by 826457 RSS

    Upgrade from 9i to 11g with chnges.

    826457
      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.