TableSplitting during a export

[Former Member]

Hi Experts,

We were doing a ASE migration.

1)We have done export preparation.

2)We have a option of table splitting preparation ...

3)Original Export (Migmon)

4)Import (Migmon)

     I have a question here on 2nd step ... Usually we try to split the tables which are large in size ... How do we calculate on how we want to split the tables?

For example: Suppose we have selected 3 tables to split as below.

TABLE1%<X>

TABLE2%<Y>

TABLE3%<X>

How can we decide the X,Y,Z values here?

Thanks in advance!!!

[former_member182657 · Accepted solution]

Hi Leela,

In response of your query

For example: Suppose we have selected 3 tables to split as below.

TABLE1%<X>
TABLE2%<Y>
TABLE3%<X>

How can we decide the X,Y,Z values here?

You have to calculate in how many packages you are going to split your "trouble table". My advice is to split a table up to packages of 5 GB max. In this case as an example, 500 GB VBOX table should split into 10 packages.Similarly you can do the calculations for other tables to decide value for X,Y & Z.

Hope this will be helpful for you.

Thanks

[former_member182657]

Hi Leela,

Kindly refer SAP note   1043380 - Efficient Table Splitting for Oracle Databases

Thanks,

Gaurav

[Former Member]

Hi Gaurav,

Thanks for your response.

Here i am using SWPM 1.0.

My Source DB is Oracle  11g.

Regards,

Leela.

[former_member182657]

Hi Leela,

SAP Note 1043380 - Efficient Table Splitting for Oracle Databases is supported for 10g or higher versions of databases i.e also for 11g.This note is specially mentioned under TADM70 OS/DB Migration guide for Table splitting purposes with details & to do faster exports by using the scripts provided with this note.So you can consider this SAP note for 11g also.

Thanks,

Gaurav