| Database Export and Import with different versions [message #179330] |
Mon, 26 June 2006 22:51  |
kumarsz
Messages: 180
Registered: March 2005
Location: canada
|
Senior Member |
|
|
Hi,
I want to import and export into databases with different versions.
Can anybody suggest me, what shall i do in following scenarios
Condition : Unable to connect to remote Target Database
Source Database : 9.2.0.6
Target Database : 9.2.0.7
Condition : Unable to connect to remote Target Database
Source Database : 9.2.0.7
Target Database : 9.2.0.6
Condition : Able to connect to remote Target Database
Source Database : 9.2.0.6
Target Database : 9.2.0.7
Condition : Able to connect to remote Target Database
Source Database : 9.2.0.7
Target Database : 9.2.0.6
Thanks in Advance,
Pratap
|
|
|
|
|
|
| Re: Database Export and Import with different versions [message #179437 is a reply to message #179432] |
Tue, 27 June 2006 07:00  |
kumarsz
Messages: 180
Registered: March 2005
Location: canada
|
Senior Member |
|
|
Many Thanks Mahesh!!!
However, two more questions here. (although i will definitely serach the forum for Details)
1)Will "Executing catexp of 9.2.0.6 Database will overwrite (drop /create) the Objects required of export/import in existing 9.2.0.7 database?
2)
Is the Export or Import utility version also matters here?
i have two databases where
DB1
Database version : Oracle9i Enterprise Edition Release 9.2.0.6.0
IMP Utility : 9.0.1.5.0
DB2
Database version : Oracle9i Enterprise Edition Release 9.2.0.7.0
IMP Utility : 9.2.0.7.0
Please suggest.
Thanks and Regards
Pratap
|
|
|
|
| Re: Database Export and Import with different versions [message #179439 is a reply to message #179437] |
Tue, 27 June 2006 07:06 |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
1.) YES. You need to re-run catexp of 9.2.0.7 again for further operations wiht 9.2.0.7. You may not want to do this in production (though harmless, do not do it, if you are not comfortable).
| Quote: |
Database version : Oracle9i Enterprise Edition Release 9.2.0.6.0
IMP Utility : 9.0.1.5.0
|
You mean to say that,
Your datbase version and it local imp version are different?
I would prefer to have them in same version.
concept is use the lower version of exp/imp tools against higher version of database
or
Run catexp.sql
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
