Table Splitting

[Former Member]

Hello,

We are doing a Database Migration of our Production system from Informix 10 to Oracle 9 with SAP R/3 4.6B...

We have a big Cluster Table CDCLS [200 GB] in our system which is taking a lot of time to do Export..approx 40 hours with Unsorted Unload...

Is there any different method to speed up the export for a cluster table...

I also would like to know how to split up a single table in [n] number of packages to speed up the export...

Thanks,

RaHuL...

[markus_doehr2 · Accepted solution]

For newer releases (6.40 and above) there is a feature called "table splitting" with the help of "R3ta" and "R3ta_hints.txt". HOwever, you release is in customer specific maintenance (very old).

I would create an OSS call (BC-INS-MIG) and ask if that feature can be provided for your version.

Markus

[Former Member · Accepted solution]

Hi,

Thanks a lot...

Actually we had asked for it the previous time when we did migration for a different landscape...

We had split a table OBJK in that case...

SAP Consultant came and did some changes at the DB level probably and ask us to run these

before starting the database export... We had to do changes in import process also...

update systables set partnum=22020099 where tabname='objk_1' and tabid=40921;

update systables set partnum=23068675 where tabname='objk_2' and tabid=40922;

update systables set partnum=24117251 where tabname='objk_3' and tabid=40923;

update systables set partnum=25165827 where tabname='objk_4' and tabid=40924;

What process is this? Are you aware about it?

Thanks,

RaHuL...