compression for oracle database and index compression during import of data

[Former Member]

Hi All,

I have a query , in order to import into oracle database and also have compression and index compression , do we have some kind of load args for r3load and also do we have to change the tpl file ?

[former_member182967]

Hello guy,

I did this kind of compression within migration project before.

I performed index compress first and then export -> import with table compress.

One thing you should take care, delete nocompress flag from TARGET.SQL (created by program SMIGR_CREATE_DDL, program SMIGR_CREATE_DDL created pure non-compression objects for these considered non-standard tables). For table columns > 255, we should not delete this flag.

Regarding to the index compress in source system, please check the following notes:

Note 1464156 - Support for index compression in BRSPACE 7.20

Note 1109743 - Use of Index Key Compression for Oracle Databases

Note 682926 - Composite SAP note: Problems with "create/rebuild index"

Best Regards,

Ning Tong

[ACE-SAP]

Hello

Technically it should work for tables, not for index compression (optimal compression option cannot be set globally but should be compute for each index).

But by adding table compression clause in the DDL<DBS>.TPL file you will activate compression for all tables, that is not recommended... as some tables should not be compressed (see note 1431296 - LOB conversion and table compression with BRSPACE 7.20)

Regards