Oracle Advanced Compression with 11gR2 / ERP 2004

[Former Member]

Hello,

I'm currently in the process of migrating one of our ERP 2004 systems to Oracle 11gR2 for assessment purposes in regard of the advanced compression feature.

Question 1: What's the best practice / easiest way to import "the data" compressed via R3load?

Here's what I did up until now:

R3load based export of the database

ERP2004 + Oracle 10gR2 Installation with sapinst

Database created, tablespaces created

Updated Database to 11gR2

Updated: Kernel, R3tools, etc.

So the next step would be to import the data compressed.

From note 1436352 I gather that NW 7.0 based sapinst versions do include an option to set up the whole system with compressed tables where feasible, that is except LOBs and the tables SAP doesn't recommend to compress. I learned from this forum, that sapinst seems to include &COMPRESS& into the CREATE TABLE statement of DDLORA.TPL

Question 2: Does anyone know if this (simply inserting &COMPRESS& into DDLORA.TPL) also works with R3load version R6.40/V1.4 Compiled Jun 28 2010 12:35:51 and R3load decides "by itself / algorithm" if a table should be created with the compress option or not.

Best Rgs your help is much appreciated,

Thorsten

[markus_doehr2 · Accepted solution]

> Question 1: What's the best practice / easiest way to import "the data" compressed via R3load?

Currently installations (and hence R3load migrations) are not supported for Oracle 11. Sapinst doesn't know "Oracle 11" so you will run into issues if you try to load the export into an Oracle 11 database (in post processing).

Markus

[Former Member]

Hello Thorsten,

SAP note 1398634 says:

"The provision of a direct installation of SAP products with Oracle Version 11.2 is currently planned for mid-November 2010."

I suggest to wait until this release, because otherwise you have to use brspace to compress your database,

which is much fun and takes ages.

Regards,

Mark

[Former Member]

Hi there,

yep, did it nevertheless (importing all the data uncompressed via R3load into Oracle 11gR2) and got all the grief.

Im currently compressing via the brspace option and are about to find out how long this actually will take.

Best practice (from my point of view) so far for anybody else to know, if you want to use Oracle 11gR2 compression:

Optional Step 1: Upgrade to 10gR2 and the "new" table space layout

Step 2: Instant Client 10.2.0.4, EXT2 Kernel, BRTOOLS 7.2 patch >= 3 (patch 7 at the time of writing)

Step 3: Upgrade Database to 11gR2

Step 4: Migrate data via BRTOOLS to compressed as described in note 1431296.

Best Rgs

Thorsten