oracle export 10G to 9i

Hi GUys

Please can some one help on how to do export for oracle database from version 10G to 9i;

I have a 9i database and I want to import from 10G and use this dump in the version 9i.

Please advise.

Thanks and regards

TaKe export of 10g database using 9i's EXP and import in 9i

Thanks for the reply.

But I try to use the exp.exe for version 9.i to do the export for 10G. and it does not work.

So please more details will be welcome.

Regards

What problem are you facing?

What happen when you are trying to take export?

I have error message about some DLL missing....for this version of export. so is like oracle expect all the necessary dll files to complete this export...

same thing happen when I use the imp.exe file for version 10G to import into
9i.... it request: oracommon10.dll

thx.

have you installed the client correctly

the problem is not even the client, because I have not install the dump yet, to use client version to access database; right now I'am just trying to import a dump that was created by oracle 10G into oracle 9i. and the import process cannot finish because the oracle version for import and export is not the same.

You cannot not import dmp file created by 10g exp.exe in 9i

Take export of oracle 10g database using Oracle 9i exp.exe.

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.

You have to check as davey23uk said.

10g and 9i on same machine ?

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 ....