Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Migration oracle 7.3.4 to oracle 9.2 using imp/exp

Status
Not open for further replies.

wovereem

Technical User
Sep 3, 2002
1
NL
Question:
I want to migratie an oracle 7.3.4 database on unix to oracle 9.2 on win2k. Is this possible using imp/exp.
 
Hi,

I found an article some times ago in metalink.oracle.com which makes it clear. Here's the sentence of this article

It's possible to migrate directly from oracle 7.3.4 to 9.0.1 The one step migration from 7.3.4 to 9i is effectuated (internally) by first moving oracle 7 to 8 and then from oracle 8 to 9.

If you want to read this article completly please go to metalink.oracle.com and search for Note:144804.1
Maybe this informations are included in the migration guides 9.0 or 9.2

good luck
regards
Uwe
 
Export/Import will work. Of course, test it first and you'll see.

The ONE ( HP-UX + Solaris + AIX + Tru64 = Unix)
 
Exp/Imp between v7 and v9.2 may not work..The version 7 export produces an unreadable dmp file for version 9.2s's import program..Version 7's import tool probably will not work with a version 9.2 database and version 9.2's exp cannot connect to a version 7 database..( Version 9.2 is much more restrictive in its backward compatibility than previous releases)

In place upgrade to Version 8.x seems to be the best option...

[profile]
 
Surely this will work. The import/export between oracle 7 and oracle 9.2.0 will work without any problem
 
Hi - muji,did you actually run a imp/export between those 2 versions..
Which EXP binary did you use and which IMP ?

Were the databases on different Servers? - which SqlNet version?

My understanding is that 9.2 is not compatible at all with any version 7 stuff...

[profile]
 
Hi again,
A further clarification of my question in my previous post:

Did you use the 7.3.4 IMP command to import into the 9.2 database and did it work..
I know the 'other way' will not ( 9.2 IMP with a 7.3.4 export dmp file - nor can you use the 9.2 EXP to access a 7.3 database - the 9.2 client software cannot communicate with a v7 database instance)

Thanks,
[profile]
 
The database versions 7.3.4 and 9.2.0.1 where on different machines. And I made export with 7.3 and imported with 9.2. This works without any problem
 
Hi.
I also had no problem exporting from 7.3.4 to 9.2. Even 7.2.2.4.0 to 9.2.0.2.0 worked without any problem (all with the binaries of the corresponding server, all under AIX). What of course will NOT work is a full export/import - all my imports were fromuser/touser imports.

Stefan
 
The full exp/imp between 7.3 to 9.2 will work fine. No need to go for user by user import
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top