2 Replies Latest reply: Aug 16, 2007 8:43 AM by 569001 RSS

    How to migrate oracle 9i database to oracle 10g

    589636
      Hi All!

      Can anyone tell me the steps to migrate oracle database from 9i to 10g.
      what are the prerequisite and preliminary thing to consider...
      any thing related to migration.

      ThanQ.
        • 1. Re: How to migrate oracle 9i database to oracle 10g
          592695
          Hi,

          u can go for any of the migration steps provided by oracle..say

          1.By using DBUA
          2.By using PL/SQL scripts provided by oracle like utlu102i.sql
          3. Using exp/imp utilities
          4. Using Copy

          For further info, u can refer 10g upgrade guide available on OTN

          Regards
          ramesh
          • 2. Re: How to migrate oracle 9i database to oracle 10g
            569001
            Which one is better?

            Thanks a lot.

            itpub888


            -----------

            Re: How to migrate oracle 9i database to oracle 10g
            Posted: Aug 12, 2007 11:17 PM

            Hi,

            u can go for any of the migration steps provided by oracle..say

            1.By using DBUA
            2.By using PL/SQL scripts provided by oracle like utlu102i.sql
            3. Using exp/imp utilities
            4. Using Copy

            For further info, u can refer 10g upgrade guide available on OTN

            Regards
            ramesh