Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004

    Question Unanswered: how to migrate database between 8i to 9i

    hi all
    i m having my database in oracle 8i. now i want to upgrade it to oracle 9i. for that what should i do. please tell me each step.
    should i uninstall my oracle 8i.

  2. #2
    Join Date
    Oct 2003
    Republic of Srpska, Bosnia and Herzegovina

    You need to install Oracle 9i in new oracle_home. Then restore your 8i database under the 9i home. There is a upgrade scripts in folder oracle_home/rdbms/admin called u0801070.sql, u0800060.sql. In then header of those files you have explanation how to use it. Run script under your new oracle_home. Also, you can use Database Upgrade Assistant to migrate your database.

    Hope this help.

  3. #3
    Join Date
    Feb 2004

    Thumbs up

    thanks that upgrate assistant works

  4. #4
    Join Date
    Feb 2004

    Re: how to migrate database between 8i to 9i

    I've been an Oracle DBA for 10 years and I have found that it is 10 times easier and safer in my humble opinion to do a full database export and a full database import. Plus, you get the benefit of cleaning up all the fragmentation in your database.

    1. Full database export from 8i using the exp utility
    2. Create a new 9i database and recreate the same tablespaces of about the same size.
    3. Full database import from the 8i dump file using the imp utility

    I would also suggest on the import using the INDEXES=N parameter, then using the INDEXFILE parameter through the imp utility to create yourself a sql script to rebuild all the indexes manually after the import has completed...

Posting Permissions

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