[rhs98]

Hello,
I really need this question answered quickly -

The problem is, I have a customer with 7.3 alpha, and we use 9i intel. Also I have a copy of 8.0.5.0.0 and we need to dump files from the later version (preferably 9i) and imp it into 7.3

My question therefore is; can imp73 read oracle 8.0.5.0.0 or 9i exp files (is there some sort of compatibility mode?)?

Oh, and using the older version of exp on the newer database won't work as they are for differing architechures (intel/alpha) and i don't have a 7.3 intel licence).
Also using CSV or other flat files is not an option - the files must be able to be imported using imp73?

Help is much appreciated!

[Ruudboy]

Hi,

I think you have to use the older version of exp. But you don't need it on the 9i server, you can just export on the 7.3 server. Using sql*net.

On the version 7 server:
exp username/password@db9i

[rhs98]

so how does this work?

I need to create the files in the exp73 format, using sql*net would not do this would it?

[Ruudboy]

Oops... I see that export 9i -> import 7.3 is not supported... you might have to have 8.0 in between.

(9i->80->73)

See this metalink doc:
http://metalink.oracle.com/metalink/..._id= 132904.1
Compatibility Matrix for Export & Import Between Different Oracle Versions

[rhs98]

so what do you suggest - what is the command syntax for making a dump file from exp80 compatible with imp73?

I could use exp73 - apart from it is the Alpha version.

[Brice]

http://oradoc.photo.net/ora817/DOC/s.../ch01.htm#4663

Use the lowest version of the tools.

[rhs98]

ok - where can i get a windows/intel copy of the exp73 tool? as I only have a copy of exp73 for windows/alpha - is this going to be freely availble or will i have to pay?