Upgrade to 8i
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Upgrade to 8i

  1. #1
    Join Date
    Feb 2002
    Posts
    18
    Hi,
    Soon I have to upgrade oracle from 7.3 to 8i on Windows NT (for the first time)
    Size of db=85 GB
    Could you please give me some steps to keep in mind and /or some documentation to?
    Read before


    Thanks


  2. #2
    Join Date
    Dec 2001
    Posts
    221
    use migration utilities
    Santosh Jadhav
    8i OCP DBA

  3. #3
    Join Date
    Aug 2000
    Location
    Belgium
    Posts
    342
    In the oracle documentation, you have the migration guide which gives you an excellent overview of the steps to be taken.
    You can find this guide at
    http://otn.oracle.com/docs/products/...a86632/toc.htm

    When you choose for export/import, the duration of the migration is determined by the size of the data in your db.

    When you choose for migration, the duration of the migration is determined by the number of objects your db contains.

    Hope this helps
    Gert

  4. #4
    Join Date
    Aug 2000
    Posts
    236
    I dont think that you can migrate using the MIG utility directly from 7.3 to 8i. You first have to move to version 8.0.4 and then to 8i.

    I belive your DB size is 85GB. Import/Export will be too time consuming.

    Nizar

  5. #5
    Join Date
    Aug 2000
    Location
    Belgium
    Posts
    342
    In the migration guide you will find the procedure to migrate the db from 7.3.4 -> 8i.

    You don't need to pass by 8.x .

    I've done it several times on NT and AIX.

    Regards
    Gert

  6. #6
    Join Date
    Feb 2002
    Posts
    18
    Denevge, did you use Migration Utility or Oracle Data Migration Assistant?
    Did you encounter any bugs, problem while migration?


    Thanks,to all

  7. #7
    Join Date
    Dec 2001
    Location
    SAN FRANCISCO, CA
    Posts
    306
    see correct me if i just wanted to have my thought on migration clear
    in this same scenario 7.3.4 to 8.1.7

    see when u decide to do migration by exp/imp

    first take a export backup of database with full=y
    u install oracle 8.1.7
    create the database /run the data dict srcipts / create temp,rollback,users tablespaces / datafiles , users .
    then import the backup. am i right ? or missing something .

    is there any sql conversion script to run. ?

    -- pravin


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