Home » RDBMS Server » Server Utilities » export 10g & import 9i (9i xp)
export 10g & import 9i [message #306861] Mon, 17 March 2008 02:19 Go to next message
nadiahq
Messages: 16
Registered: March 2008
Location: KSA
Junior Member

hi dear,
i exported 1 table from 10g database.now i want to import
9i database.two database in two different terminal.can i do this
one. i didn't use expdp command while i was exporting from 10g.
it showing error msg
IMP-00058 :ORACLE error 12145 encountered
ORA-12154 :TNS:could not resolve service name
IMP:00000 :Import terminated unsuccesssfully
Re: export 10g & import 9i [message #306869 is a reply to message #306861] Mon, 17 March 2008 02:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to use 9i export binary if you want to then import in 9i.

Regards
Michel
Re: export 10g & import 9i [message #306928 is a reply to message #306869] Mon, 17 March 2008 05:29 Go to previous messageGo to next message
nadiahq
Messages: 16
Registered: March 2008
Location: KSA
Junior Member

sorry my dear
i doesn't clear at all.can u explain breifly how to export 9i binary.
Re: export 10g & import 9i [message #306930 is a reply to message #306928] Mon, 17 March 2008 05:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have export program with 9i binaries.
# exp help=y

Export: Release 9.2.0.8.0 - Production on Mon Mar 17 11:32:39 2008

You have export program with 10g binaries.
# exp help=y

Export: Release 10.2.0.3.0 - Production on Mon Mar 17 11:32:22 2008

You need to export with the former one if you want to import in a 9i database.

Regards
Michel


Re: export 10g & import 9i [message #306963 is a reply to message #306930] Mon, 17 March 2008 06:39 Go to previous messageGo to next message
nadiahq
Messages: 16
Registered: March 2008
Location: KSA
Junior Member

i doesn't have this release.so may i need to download.
Re: export 10g & import 9i [message #306968 is a reply to message #306963] Mon, 17 March 2008 06:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Didn't you say you want to export from 10g into 9i database?
So you have both versions, doesn't it.
If not, yes you have to download the missing one.

Regards
Michel
Re: export 10g & import 9i [message #306972 is a reply to message #306968] Mon, 17 March 2008 07:05 Go to previous messageGo to next message
nadiahq
Messages: 16
Registered: March 2008
Location: KSA
Junior Member

i didn't have same version.i have with different patch
like for 9i(9.2.0.10).But as mention release number i don't have update release.
Re: export 10g & import 9i [message #306984 is a reply to message #306972] Mon, 17 March 2008 07:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Patch number does not matter (unless you fall in a bug).
Just version on 2 digits must match with your database versions.

Regards
Michel
Re: export 10g & import 9i [message #307279 is a reply to message #306984] Tue, 18 March 2008 05:42 Go to previous messageGo to next message
nadiahq
Messages: 16
Registered: March 2008
Location: KSA
Junior Member

i don't know how to binary exp 9i.because for windows platform i know its already binary.
still i am not clear.is it possible exp higher version and imp lower version.
pls let me know clearly.
Re: export 10g & import 9i [message #307286 is a reply to message #307279] Tue, 18 March 2008 05:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
is it possible exp higher version and imp lower version.

Yes, if you use the export program from the lower version.
Hope the answer is clear.

Regards
Michel
Re: export 10g & import 9i [message #307287 is a reply to message #306869] Tue, 18 March 2008 06:00 Go to previous messageGo to next message
nadiahq
Messages: 16
Registered: March 2008
Location: KSA
Junior Member

now its giving me following error:
IMP-00010: not a valid export file, header failed verification ...
Re: export 10g & import 9i [message #307325 is a reply to message #307287] Tue, 18 March 2008 08:21 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
You have mode one of two errors:

1. You have ignored being told at least two times that you have to export with the LOWER version of the export command in order to import into a lower version of the database.

2. You have ftp'd the file from one box to another using an ascii transfer.

I have no idea what this sentence from you means:
i don't know how to binary exp 9i.because for windows platform i know its already binary.


Please use correct punctuation.
Re: export 10g & import 9i [message #307553 is a reply to message #307325] Wed, 19 March 2008 02:04 Go to previous messageGo to next message
nadiahq
Messages: 16
Registered: March 2008
Location: KSA
Junior Member

Really sorry for that my dear.Actually i don't know how to use 9i exp binary.
Re: export 10g & import 9i [message #307720 is a reply to message #307553] Wed, 19 March 2008 12:12 Go to previous message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
export command is the same for 9i and 10g. It's simply exp. On the server with 9i, create an export, ftp the export file in binary format to the server with 10g and then import it with the 10g import command. QED.
Previous Topic: exp/imp error
Next Topic: Why was some table imported to another tablespace?
Goto Forum:
  


Current Time: Mon Dec 05 06:58:01 CST 2016

Total time taken to generate the page: 0.06570 seconds