Migration oracle 7.3.4 to oracle 9.2 using imp/exp

[wovereem]

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.

 

[appi]

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

 

[cgswong]

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

The ONE ( HP-UX + Solaris + AIX + Tru64 = Unix)

 

[Turkbear]

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...

 

[muji]

Surely this will work. The import/export between oracle 7 and oracle 9.2.0 will work without any problem

 

[Turkbear]

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...

 

[Turkbear]

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,

 

[muji]

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

 

[stefanhei]

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

 

[muji]

The full exp/imp between 7.3 to 9.2 will work fine. No need to go for user by user import