Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Importing 9i to 8i
- Thread starter Joeyp
- Start date
Hello again 
Yes, Its in the documentation
Use the 8i export against the 9i database, then import into the 8i database
Alex
Yes, Its in the documentation
Use the 8i export against the 9i database, then import into the 8i database
Alex
JamesGordon
Programmer
Not using export!
you could try to import using indexfile=... on 9i to get the tables and indexes script and run that against your 8i database. Then using SQL*Plus' copy command copy the data across.
This would still leave you with a problem of triggers, packages etc.
Hope it gets you on your way?
The problem is that 8i doesn't know anything about 9i and would choke on some of the functionality the 9i export might contain and requests for non-existant core tables.
you could try to import using indexfile=... on 9i to get the tables and indexes script and run that against your 8i database. Then using SQL*Plus' copy command copy the data across.
This would still leave you with a problem of triggers, packages etc.
Hope it gets you on your way?
The problem is that 8i doesn't know anything about 9i and would choke on some of the functionality the 9i export might contain and requests for non-existant core tables.
I've never actually tried Alex's suggestion, but I've read that this is a standard technique for migrating data to a lower version of Oracle. I would give it a try.
As Alex says, the key is to do the export using the 8i export utility. If you try to export with 9i and then import to an 8i database you are guaranteed to have compatibility problems.
As Alex says, the key is to do the export using the 8i export utility. If you try to export with 9i and then import to an 8i database you are guaranteed to have compatibility problems.
This is a well documented issue on Metlink - always use the export program from the lower version number of Oracle when moving data from one version to another. There may be a special script that has to be run within the higher version you are exporting from in order to use the 8i exp.exe. See the Oracle doc on metalink for this.
- Status
Similar threads
