cancel
Showing results for 
Search instead for 
Did you mean: 

R3load Import ( Import from 8.1.7 to Oracle 10.2.0.2 directly )

Former Member
0 Kudos

Hi,

We are planning to perform a test R3load system Copy Export and Import.

Source version ; oracle 8.1.7

OS; Solaris 8

R/3 4.6C

Target version ; oracle 10.2

OS; Solaris 10

R/3 4.6C

Actually I'm performing an upgrade to ECC 6 using Unix and oracle 8.1.7 using R3Load.

For ECC 6 it's mandatory to upgrade to Oracle 10.

Instead of upgrading the oracle from 8.1.6 --> 9.2.0 --> 10.2.0 step by step, can I just install Oracle 10 and import the files using R3Load?

Also kindly refer me some relevant Notes / Installation Guides.

Best Regards

Kishore

Edited by: PSC0459 on Jun 17, 2008 12:11 PM

Accepted Solutions (1)

Accepted Solutions (1)

markus_doehr2
Active Contributor
0 Kudos

>

> Hi,

>

> We are planning to perform a test R3load system Copy Export and Import.

>

> Source version ; oracle 8.1.7

> OS; Solaris 8

> R/3 4.6C

>

> Target version ; oracle 10.2

> OS; Solaris 10

> R/3 4.6C

>

> Actually I'm performing an upgrade to ECC 6 using Unix and oracle 8.1.7 using R3Load.

> For ECC 6 it's mandatory to upgrade to Oracle 10.

>

> Instead of upgrading the oracle from 8.1.6 --> 9.2.0 --> 10.2.0 step by step, can I just install Oracle 10 and import the files using R3Load?

yes - that works.

The easiest way would be to install a 46D_EX2 kernel and use the instantclient instead of the Oracle 9.2 client with the standard 46D kernel.

Apart from that it should be pretty straightforward.

Markus

Answers (1)

Answers (1)

andreas_herzog
Active Contributor
0 Kudos

as far as i recall you can either

a) export 8.1.7 and import into 9.2

or

b) export 9.2 and import into 10.2

so you'd rather make the upgrade to oracle 9.2 on the source system and make the export usind r3load...

the oracle dump utility could be used to import an 8.1.7 export into 10.2, but i'm not sure if SAP supports that (a direct upgrade from 817 to 102 ist not supported by sap, but possible according to oracle information)

-> http://youngcow.net/doc/oracle10g/server.102/b14238/expimp.htm

GreetZ, AH