7 Replies Latest reply on Dec 9, 2012 4:36 PM by 826457

    Upgrade from 9i to 11g with chnges.

      Hi All,

      Please suggest for best practise.

      we habe to upgrade production database which is in to, 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.