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

    Question Unanswered: Migrating Oracle v8.1.7 to v9.


    I need to migrate oracle v8.1.7 to v9. 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


  2. #2
    Join Date
    Aug 2004
    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
    Dominican Republic
    We are on the same boat here, from v8.1.7 to v9., 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
    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

  5. #5
    Join Date
    Aug 2004

    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 ( 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