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.
[EMAIL PROTECTED]
-----Original Message-----
Sent: Wednesday, July 23, 2003 6:49 AM
To: Multiple recipients of list ORACLE-L
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.
........................
Tia,
Jeroen
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
