OraFAQ Forum: Backup & Recovery » Database Export and Import with different versions

Home » RDBMS Server » Backup & Recovery » Database Export and Import with different versions

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

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

Report message to a moderator

Re: Database Export and Import with different versions [message #179432 is a reply to message #179330]

Tue, 27 June 2006 06:53

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Whatever the case may be,
there are only two methods.
1. Use lower version of exp to export and lower version of imp to import
or
2. install version of exp/imp views by running catexp.sql
If you want to export/import 9.2.0.6 database using 9.2.0.7 version of exp, then run catexp of 9.2.0.6 against 9.2.0.7 database.
Search the forum for more details.

Report message to a moderator

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

Report message to a moderator

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: 10708
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

Report message to a moderator

Previous Topic:	Request Expert Critic for an Article I found
Next Topic:	Cloning Database - Document

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 00:50:34 CST 2025