oracle export 10G to 9i

Quote:

---

Originally Posted by jfassinou

that was done but as I said above, there is error msg about some of the DLL missing; when you try to use exp.exe for 9.i on 10G.

---

Please describe the procedure you followed to use Ora9i export on Ora10g database.

nope they both database are in separate machines. so now i have installed oracle 10G client version on the same machine where the 9.i db is running from, so where I try import now I have this:

Import: Release 10.2.0.1.0 - Production on Wed Sep 5 14:21:44 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.


IMP-00058: ORACLE error 6550 encountered
ORA-06550: line 1, column 33:
PLS-00302: component 'SET_NO_OUTLINES' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
IMP-00000: Import terminated unsuccessfully

No need to install 10g client at 9i machine.

Just configure tnsnames.ora at 9i machine.

Use exp.exe from 9i machine and take export of 10g db. Here use connect string in userid parameter of EXP command (as configure in tnsnames).

Take import of that DMP in 9i using 9i's imp.exe.

Thanks bhattnirav for your advise,

my problem is now resolved after I take a dump from 10G using the imp.exe of 9.i

Regards

JF

Install 9i on a machine where there is no 10g. The do the exp.exe

Quote:

---

Originally Posted by dba1

Install 9i on a machine where there is no 10g. The do the exp.exe

---

Huh?!

By the way, why in the world you reopened a thread where on the last post the original poster states the problem has been solved?

and then post crap ....