Oracle 8 to Oracle 7 - Database Migration possible?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Oracle 8 to Oracle 7 - Database Migration possible?

  1. #1
    Join Date
    Jan 2000
    Location
    toronto
    Posts
    3

    Question

    Hi everyone,
    Was wondering if Database Migration was possible from an Oracle 8 database to an Oracle 7.3 environment?

    Could you please let me know? Thanx a bunch.

    Frank

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Using oracle migration work bench, you can possibly do this. But you will be loosing lots of schema objects, which would become invalid.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    If by "migration" you mean "not recreating the database" then the answer is NO. The only option you have is to export 8i database with 7.3 export utility, create a new 7.3 database and import the dmp int the new database.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  4. #4
    Join Date
    Aug 2000
    Location
    Toronto, Ontario Canada
    Posts
    52
    Oracle Migration Workbench is for migrating non-oracle database (like sqlserver, access,db2, informix, etc ) to Oracle.

    You can downgrade to 7.3 of Oracle.
    You can export the Oracle 8 db to an 7.3 home.
    You may need to run some scripts to build the appropriate views. Check out the migration guide for 8.0. There's a section regarding downgrading...

  5. #5
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Thanks steviep9 for pointing that out. My brains are out of sync today :O

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  6. #6
    Join Date
    Feb 2001
    Posts
    41

    8 to 7 Migration Possible

    What you have to do is you go to Oracle8 home first and run catexp7.sql What this will do is that!! it will let you export the views and other objects which needs to be oracle7.x way specifically. Make sure you use export/import method.
    I have used this for couple of times once you run this script and make a full export from 8 and import full=y in to oracle7.3 then you need to run catlog.sql ,catproc.sql and utlrp.sql to make sure that all you data/plsql objects are in valid status and ready for use of production.
    If you get any error then feel free to email me.
    Best Regards,
    Harsh Shah

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