OraFAQ Forum: Server Utilities » export 10g & import 9i

Home » RDBMS Server » Server Utilities » export 10g & import 9i (9i xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

export 10g & import 9i [message #306861]

Mon, 17 March 2008 02:19

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

Report message to a moderator

Re: export 10g & import 9i [message #306869 is a reply to message #306861]

Mon, 17 March 2008 02:33

Michel Cadot
Messages: 68652
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

Report message to a moderator

Re: export 10g & import 9i [message #306928 is a reply to message #306869]

Mon, 17 March 2008 05:29

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.

Report message to a moderator

Re: export 10g & import 9i [message #306930 is a reply to message #306928]

Mon, 17 March 2008 05:33

Michel Cadot
Messages: 68652
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

Report message to a moderator

Re: export 10g & import 9i [message #306963 is a reply to message #306930]

Mon, 17 March 2008 06:39

nadiahq
Messages: 16
Registered: March 2008
Location: KSA

Junior Member

i doesn't have this release.so may i need to download.

Report message to a moderator

Re: export 10g & import 9i [message #306968 is a reply to message #306963]

Mon, 17 March 2008 06:45

Michel Cadot
Messages: 68652
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

Report message to a moderator

Re: export 10g & import 9i [message #306972 is a reply to message #306968]

Mon, 17 March 2008 07:05

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.

Report message to a moderator

Re: export 10g & import 9i [message #306984 is a reply to message #306972]

Mon, 17 March 2008 07:22

Michel Cadot
Messages: 68652
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

Report message to a moderator

Re: export 10g & import 9i [message #307279 is a reply to message #306984]

Tue, 18 March 2008 05:42

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.

Report message to a moderator

Re: export 10g & import 9i [message #307286 is a reply to message #307279]

Tue, 18 March 2008 05:54

Michel Cadot
Messages: 68652
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

Report message to a moderator

Re: export 10g & import 9i [message #307287 is a reply to message #306869]

Tue, 18 March 2008 06:00

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

Report message to a moderator

Re: export 10g & import 9i [message #307325 is a reply to message #307287]

Tue, 18 March 2008 08:21

joy_division
Messages: 4963
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.

Report message to a moderator

Re: export 10g & import 9i [message #307553 is a reply to message #307325]

Wed, 19 March 2008 02:04

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.

Report message to a moderator

Re: export 10g & import 9i [message #307720 is a reply to message #307553]

Wed, 19 March 2008 12:12

joy_division
Messages: 4963
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.

Report message to a moderator

Previous Topic:	exp/imp error
Next Topic:	Why was some table imported to another tablespace?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 17 04:26:07 CDT 2024