Skip to Content
0
Jul 04, 2011 at 06:58 PM

Slow R3Load export for a specific table

996 Views

Hello,

We are currently migrating from ECC5 to ECC6 EhP4.

We use R3Load to export/import ou Oracle 10 Sap DB.

We had to cancel the export as it was going to take days to export a specific table.

Exporting all the other tables took a few hours.

We had exported it with exp, truncated it and restarted sapinst so that we could migrate.

The structure of the table is:

SQL> desc sapprd.zcl_dao_stat

Name Null? Type

-


MANDT NOT NULL VARCHAR2(3)

NOACC NOT NULL VARCHAR2(10)

TABNAME NOT NULL VARCHAR2(30)

TABPAR NOT NULL VARCHAR2(30)

WHERE_STRING CLOB

FAE_WHERE_STRING CLOB

TCODE NOT NULL VARCHAR2(20)

REPID NOT NULL VARCHAR2(40)

CPROG NOT NULL VARCHAR2(40)

ERNAM NOT NULL VARCHAR2(12)

ERDAT NOT NULL VARCHAR2(8)

ERTIM NOT NULL VARCHAR2(6)

SQL> select count(*) from sapprd.zcl_dao_stat;

COUNT(*)

-


1184716

The size whithout the LOB is 300 MB.

The exp.dmp file size is 500 MB.

R3Load was exporting 1 MB per hour.

1. Would you know why R3Load was taking so much time for this table?

2. What could I change to this table to speed up the R3Load export?

3. Does Sap Oss offer support to debug why R3Load is slow on ZTables?

4. Would think that it would have also cause a slow R3Load import on the target system?

Thanks in advance for your answers.