Home » RDBMS Server » Server Utilities » Import Oracle 10g dump into 9i database (Oracle 10.2.0.4.0 and Oracle 9.2.0.6.0 on RHEL)
Import Oracle 10g dump into 9i database [message #449667] Wed, 31 March 2010 06:25 Go to next message
chetanaZ
Messages: 132
Registered: October 2009
Location: UK
Senior Member
Hi,

If I want to import 10g export dump file in to the 9i database, I am connecting to 10g database from 9i database using
exp user/password@10gdb ....

However is there any option like executing 9i catexp.dat on 10g database and do the export from 10g database itself to be imported into 9i?

Thanks and Regards,
Chetana
Re: Import Oracle 10g dump into 9i database [message #449669 is a reply to message #449667] Wed, 31 March 2010 06:34 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use the 9i exp to export the data.

Regards
Michel
Re: Import Oracle 10g dump into 9i database [message #449671 is a reply to message #449667] Wed, 31 March 2010 06:40 Go to previous messageGo to next message
chetanaZ
Messages: 132
Registered: October 2009
Location: UK
Senior Member
Many Thanks Michel.

The same message I read, but I am unable to interpret, undestand how I could do that!

Is 'using 9i exp' is different option than what I described in my last thread

i.e. from 9i database server 
exp user/password@10gdb ....


If the method to 'use 9i exp' is different to this then please let me know.

Also does the catexp workaround won't work in this 10g->9i scenario?

Thanks and Regards,
Chetana



Re: Import Oracle 10g dump into 9i database [message #449676 is a reply to message #449671] Wed, 31 March 2010 07:12 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I never export through the network it is a waste of time and resource. Use a 9i exp on the 10g server and then transfer the dump file (possibly after compressing it).
However, if this is one-shot export, you can try to do it through as you mentioned.

Regards
Michel
Re: Import Oracle 10g dump into 9i database [message #449678 is a reply to message #449667] Wed, 31 March 2010 07:19 Go to previous messageGo to next message
chetanaZ
Messages: 132
Registered: October 2009
Location: UK
Senior Member
Michel,

Thanks for your efforts and really Sorry for my ignorance

I am really not clear about your following statement
Quote:

Use a 9i exp on the 10g server


How I can do that?

Could you please elaborate it for me?

Thanks and Regards,
Chetana
Re: Import Oracle 10g dump into 9i database [message #449682 is a reply to message #449678] Wed, 31 March 2010 07:29 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The safest way is to install a 9i client on the database server then to use this one to export.

Regards
Michel
Re: Import Oracle 10g dump into 9i database [message #449689 is a reply to message #449667] Wed, 31 March 2010 08:08 Go to previous message
chetanaZ
Messages: 132
Registered: October 2009
Location: UK
Senior Member
Ok. Got it now

Thanks Michel

Regards,
Chetana

Previous Topic: User Creation Definition in User Mode Export
Next Topic: load / unload csv file
Goto Forum:
  


Current Time: Fri Mar 29 06:21:30 CDT 2024