migrate oracle8i to oracle 9i database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: migrate oracle8i to oracle 9i database

Hybrid View

  1. #1
    Join Date
    Sep 2001
    Posts
    120

    Exclamation

    i am new to dba and i am working on oracle 8i but our company want to port to oracle 9i and i want to migrate my database to oracle 9i.

    i have got a clean install of oracle 9i on redhat 7.1 with all the required parameters.i also made a default database and it up and running.

    i now want to migrate my oracle 8i to 9i without using the utilities given my oracle o r say manually.

    please let me the procedure.

    thanx

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    IS both your databases 8i and 9i on the same server. On that case use oracle data migration assistant. Otherwise use export and import (personally I would prefer this)...

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Sep 2001
    Posts
    120

    oracle 8i and oracle9i

    thanks sam,

    but they r not on same server as both the requirement for 8i and 9i r different.

    8i need glibc 2.2 kernel-2.1.4
    9i need glibc 2.2 kernerl -2.2.2

    but exp and import such a huge database would take a lot of time.


    saurabh

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Do a Full export of 8i and then import it into 9i. You could also look into that of using oracle migration work bench.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width