| Importing into lower version using (exp/imp) [message #490777] |
Thu, 27 January 2011 05:33  |
OraKaran
Messages: 183
Registered: March 2008
Location: United Kingdom
|
Senior Member |
|
|
Hello
For importing higher version database exp dump e.g. 10g exp dump into 9i database it is suggested at many places
"Always use a version of the EXPORT utility that is equal to the lowest version of either the source or the target database"
I understand from this is, I will be using 9i exp utility for exporting 10g database
I would like to know the ways it can be achieved.
1) Installing oracle 9i client on 10g database
Do I still need to execute 9i catexp.sql after that?
If answer to above is 'yes', I assume catexp.sql of 9i wont be created after 9i client is installed as such I will need to copy it from 9i database server and execute on 10g database server. Correct?
For above question I have assumed catexp.sql has different contents for 9i and 10g
2) After configuring tns file in 9i database, can I use?
exp user/password@10gdbconnstring ....
(of course for small amount of data)
Is there any other option for achieving the same?
Also I understand export and import between any 9.* into any 9.* wont be issue e.g. import from 9.2 into 9.1
Similarly any 10.* to another 10.* wont be issue.
Correct?
Regards,
OraKaran
|
|
|
|
|
|
| Re: Importing into lower version using (exp/imp) [message #490780 is a reply to message #490778] |
Thu, 27 January 2011 05:46  |
OraKaran
Messages: 183
Registered: March 2008
Location: United Kingdom
|
Senior Member |
|
|
Thanks Mahesh
Quote:
Just install 9i client in a separate ORACLE_HOME, not even need to be in the same server
Wont it increase network traffic?
Box A is 10g database server
Box B is 9i database server
Box C is 9i client
In above case Box B will read from Box A and will created dump at say Box B, wont it be slow?
I may be making mistake hear but please clear my understanding
Also I assume your answer suggest wherever I install 9i client, I dont need to execute catexp.sql over it.
Could you please suggest on another questions in earlier post as well?
Regards,
OraKaran
|
|
|
|
|
|
| Re: Importing into lower version using (exp/imp) [message #490839 is a reply to message #490829] |
Thu, 27 January 2011 11:06 |
OraKaran
Messages: 183
Registered: March 2008
Location: United Kingdom
|
Senior Member |
|
|
Thanks Michel
I hope I am not stretching it
1) Ok. I install oracle 9i client on machine same as 10gb server or another one. Fine. But over to that do I need to execute catexp.sql?
How about following option for small amount of data
2)After configuring tns file in 9i database, can I use?
exp user/password@10gdbconnstring ....
(of course for small amount of data)
Thanks and Regards,
OraKaran
|
|
|
|
|
|
| Re: Importing into lower version using (exp/imp) [message #490918 is a reply to message #490842] |
Fri, 28 January 2011 03:03 |
OraKaran
Messages: 183
Registered: March 2008
Location: United Kingdom
|
Senior Member |
|
|
Thanks Michel
1) Got it correctly now
2) No. Here I was expecting 10g db server and 9i db server are different boxes. But yes, if those are on same box I wont need tns and will only switch ORACLE_SID as you have mentioned.
Thanks and Regards,
OraKaran
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
