Oracle 8 to Oracle 7 - Database Migration possible?

[frankk]

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

[sambavan]

Using oracle migration work bench, you can possibly do this. But you will be loosing lots of schema objects, which would become invalid.

Sam

[jmodic]

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.

[steviep9]

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

[sambavan]

Thanks steviep9 for pointing that out. My brains are out of sync today :O

Sam

[hbk_emp]

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.