0 Replies Latest reply: Nov 4, 2012 1:46 PM by user1933471 RSS

    Migrate Oracle 9.2.0.5 to 11g -appreciate help

    user1933471
      Hi,
      I am currently running oracle 9.2.0.5 in winodws 2003 standard edition 32 bit. I want to move the database to a new windows 2008 R2 64bit server.

      My database is very simple and small with 8gb data (it has 320 tables, 85 views, 40 packages, 54 procedures, 20 functions, 100 triggers and 95 sequences to highlight a few).

      I would like to know what are the best possible options available for a smooth transition of moving the data to a new winodws 2008 64 bit server.

      Questions:

      1. Is it possible to install oracle 9.2.0.5 64 bit in windows 2008 64 bit server?

      2. If I install oracle 11g 64 bit in winodws 2008 server, how can I move the data from current server 2003 with oracle 9.2.0.5? Is is possible to move the data without upgrading to oracle 9.2.0.8?

      Your help would be highly appreciated.

      Thanks,
      Sundar
      (nmsundar@hotmail.com)