RE: backwards export

Jeroen

    I haven't done this specific export/import. Hopefully someone who has will respond. The usual prescription is to use the exp binary from the older Oracle version to export the data. The layout of the data files changed between Oracle 7 and Oracle 8, but did not change from 8 to 9, so you might specifically look for instructions on moving data from 8 back to 7. I have seen people on this list that have done that.

    You might also start considering how you will confirm data integrity after the data movement. Audit your data to see which data types you use.

     In the worst case, you might have to install an Oracle 8 or 8i instance and move the data in two steps. Hopefully it won't come to that.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
From: Jeroen van Sluisdam [mailto:jeroen.van.sluisdam_at_vrijuit.nl] Sent: Wednesday, July 23, 2003 6:49 AM
To: Multiple recipients of list ORACLE-L 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 - 08:02:07 CDT