Re: backwards export

I'm not sure of the export compatibility, but you should know that 9i clients won't talk to a 7.3.4 database, and 7.3.4 clients won't talk to a 9.2 database, which could be a problem. At least, they're not certified to talk to each other, which isn't quite the same thing.

Cheers
Simon Anderson

Jeroen van Sluisdam <jeroen.van.sluisdam_at_vrijuit.nl> Sent by: ml-errors_at_fatcity.com
23/07/2003 12:49
Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        backwards export

Hi,  

We are investigating possibilities for migration of an oracle 7.3.4 to oracle 9i. We want to separate our
production DB from the app-logic such that we can migrate from oracle 7.3.4 on hp-ux 10.20 to oracle 9i
on hp-ux 11. Problem is our development and test-environment because we cannot separate the logic at the
same time here also from the db (costs). Does anyone have any experience with exporting from oracle 9i
to oracle 7.3.4 ?  

I found the underlying note on metalink about the same problem but with oracle 8. I have limited experience on oracle8 and none on oracle 9. So I hope you can give some tips.
...........................

You need to run the 7.3 version of export against your 8.0 database via sqlnet/net8. Beforehand, you need to run rdbms/admin/catexp7.sql against your 8.0 database. This creates the 7.3 export views required. Note that if you have used any 8.0 specific features (e.g. objects) these will not be exported for obvious reasons.
.........................
Received on Wed Jul 23 2003 - 06:52:16 CDT