OS/DB migration tips for very large tables.

[Former Member]

Hi,

We are doing os/db migration of 4.6C system with oracle 8174. we have very large table about 130gb which is taking very long with R3load. Do we have any work arrounds.

Regards

Madhu

[former_member185954 · Accepted solution]

Hi Madhu sudhan,

I know that Oracle 9 and higher provide better options to copy large tables.

check the following notes:

Note 1045847 - ORACLE DIRECT PATH LOAD SUPPORT IN R3LOAD

Note 936441 - Oracle settings for R3load based system copy

However for Oracle 817 i don't know much.

I found a table splitting procedure in system copies from WAS 6.40 onwards.

Note 952514 - Using the table splitting feature

Also, you can look at the following note for a freeware using perl script to split table/packages.

Note 200444 - SPLITSTR.PL: Splitting STR-Files

Hope all this helps.. although couldn't format it into bullet points

Regards,

Siddhesh

[Former Member]

Is it a homogenous system copy? Why don't you give us the detail of your project description.