System Copy: The target database is twice the size of the source database

[Former Member]

Hi Experts,

We are on migration project and as of part of this, during the import ofthe BWP System, we notice that the target database is almost twice of the

size as the source database. One of the things that we see, is that tables and partitioned tables are much larger compared to the source tables. Please refer to the attached images where the findings are explained.

Some details:

1.- For database export, we run the “SMIGR_CREATE_DDL” report, and put the DDL statments on “EXPORT DIRECTORY”

2.-  We use R3ta Tool for preparing the table Split for the following tables:

/BI0/ASRCT_DS140%4

/BIC/AZMM_MAT40%10

/BIC/AZSC_0240%7

/BIC/AZSC_O0140%5

“WHR” Files Generated.

3.- During phase “ABAP IMPORT” the size of the target database increased considerably:

The size of the source database is 1482.89 GB (databases.png)

The actual size of the target database is 2530.90 GB (databases.png)

Comparison of Table "/BIC/AZMM_MAT40" between databases (MAT40.png)

Comparison of Partitioned Table "/BIC/B000098000" between databases (98000.png)

This situation is affecting the cost of disk space

We hope that you can help with this issue.

Best Regards

[former_member188883]

Hi Francisco,

1) Do you have same database version and patch level in source and target ?

2) What is the source OS and target OS ?

Regards,

Deepak Kori

[Former Member]

Hi Deepak,

Thanks for answer:

1.- We have in Source system Oracle 11.2.0.2.0 and in Target System Oracle 11.2.0.3.0

2.- Source OS is AIX, Target OS is Linux Red Hat

Do you think that could be the problem?

Last week I made a "System Copy" also from AIX to LINUX without this problem. The difference is that the other was not a BW system, was a 100gb ERP

Regards