Import Oracle 10g dump into 9i database [message #449667] |
Wed, 31 March 2010 06:25 |
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 #449671 is a reply to message #449667] |
Wed, 31 March 2010 06:40 |
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 #449678 is a reply to message #449667] |
Wed, 31 March 2010 07:19 |
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
|
|
|
|
|