Export/Import from
Oracle 7 to 8 databases is easy, since the Oracle 8 import utility (imp
for Unix, imp80.exe for NT) is able to read export files from an Oracle
7 database. However, if you try to import objects from an Oracle
8 Database into a Oracle 7 DB, you'll find the Oracle 7 import utility
cannot read export files created from the version 8 export util. In order
to do so, you'll need the following trick.
1.Prior to starting,
be sure you have full access to the source and target database. The source
database should be on Oracle 8.x while the target database should be Oracle
7.x
2. In
the $ORACLE_HOME of the V8 DB, run the script catexp7.sql against the V8
DB. This will create the necessary tables while are needed
by the V7 export util. Be sure to run this script as SYS or internal.
3. In
the $ORACLE_HOME of the V7 DB, create a tnsnames.ora file for the V8 database.
This file usually is located in $ORACLE_HOME/network/admin. For help in
creating this file, click here.
Be sure to test the connectivity before continuing.
4. Run the V7 export
util, and connect to the V8 database using a remote SQL*NET connection.
<username/password@CONNECT_STRING>. Then export the needed objects.
Basically, you'll need
to export the V8 objects using the V7 export util in order to import them
back into a V7 database.
