I just tried using and 8.1.6 export utility against a 9.2.0.5 db without a problem, but that's not an apples to apples comparison...

Basically the rule is the exp/imp utility you're using needs to be able to read all of the system catalog tables/views it uses to get information for all objects being exported/imported. If the imp/exp utility is looking for a system catalog object that has been removed/changed/replaced in another version, it will fail.

Also, if you try to import a dump file of a different version than the one used to export, then a change in file header format/info between versions might cause the imp.exe not to be able to read the dump file header.

So, in your case, you'll have to try the 8.1.7 exp.exe on the 10g db (as Mark has indicated)...that may or may not work.

If it does, you're all set. If it doesn't, then you're left with exporting with 10g exp and importing with 8.1.7 imp. It is unlikely that an 8.1.7 imp.exe will be able to read a 10 .dmp file, and it is also unlikely that a 10g imp will be able to imp into a 8.1.7 db.

would test it if I had the right versions :-)

Steve



-----Original Message-----
From: Islam Farhadul
[mailto:oracledba-ezmlmshield-x51508984.[Email address protected]
Sent: Tuesday, December 28, 2004 4:13 PM
To: LazyDBA Discussion
Subject: RE: exp/imp Compatibility



Hi All,

I need to take an exp from 10g and want to imp into 8.1.7 running DB. Is
it possible to do that? Do I need to run any script (like "catexp.sql")?



Thanks,

FI


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page