Index Creation during DB Migration

[Former Member]

Hello,

We are doing a DB Migration from Informix 10 to Oracle 9.2.0.1.8...

We have a big table OBJK of size 330 Gb with indexes of 105 gb...i.e total to 435 gb...

Total no.of records in table are 1860 million...

There is one index which is size 84 gb...

What is the fastest way to create the index...

Thanks,

RaHuL...

[stefan_koehler · Accepted solution]

Hello Rahul,

the fastest way to do this is a parallel index creation.

I have used the Distribution Monitor (sapnote #855772) for all my migrations of the big systems (> 2.5 TB) and there is a parameter called "parallel_index_import".

Just check this note and the attached documentation - the parameter info describes how it works:

For parallel index creation during import DDL<dbtype>_LRG.TPL template file is required. Currently only supported by Oracle database

If you are not using the distribution monitor you can implement this manually with this information.

Regards

Stefan

[Former Member · Accepted solution]

But we are on SAP R/3 4.6B and kernel 4.6B & Oracle 9.2.0.8...

Thanks,

RaHuL...