Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2003
    Location
    Melbourne, Australia
    Posts
    53

    Question Unanswered: Migrating Oracle v8.1.7 to v9.2.0.1.0

    Guys,

    I need to migrate oracle v8.1.7 to v9.2.0.1.0 on AIX. Even the OS, which is currently v4.3.3, will be migrated to v5.2

    What are the pit falls, if any?? Any help on this appreciated

    -Raghavan

  2. #2
    Join Date
    Aug 2004
    Posts
    5
    I heard the in-place migration works well, however, I took the new db install with export/import route. I wanted a clean home dir and all. There will be some problems but everyone's will be different, that's oracle forte.

  3. #3
    Join Date
    May 2004
    Location
    Dominican Republic
    Posts
    721
    We are on the same boat here, from v8.1.7 to v9.2.0.1.0, but same OS. Anyone has "any pit falls" ( if any ) with that ? .. I am affraid we are going to have huge problem since we run a legacy application made in Developers...

  4. #4
    Join Date
    Sep 2003
    Posts
    237
    1)I did use dbua(database upgrade assistant; 2)i used conversion scripts;3) i created a dtabase and imported an exported db; all were very smooth. If there are too many constraints,interdependencies etc 3 may be problematic; depends on your situation. i also used dblinks to INSERT INTO ... SELECT FROM... For a db with very large tables
    mota

  5. #5
    Join Date
    Aug 2004
    Posts
    18

    migrate data from Oracle 8 to Oracle 9

    If you need quickly migrate data from Oracle 8 to 9 you may want consider try WisdomForce FastReader (www.wisdomforce.com). FastReader unload Oracle tables into flat text, generates control files for loaders and also generate scripts to enable / disable constrains. It support various platforms, like Oracle 8 can run on Solaris and Oracle 9 on HPUX or Windows. I am using FastReader when I need quick snapshot of production data fromOracle and move it to test environment in MySQL

Posting Permissions

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