SAP/Oracle OLTP compression after migration

[alicifci]

Hi all,

I did an export/import SAP/Oracle 11 from Windows 2003 to Windows 2016 and Oracle 12.2.

I forgot to check the option to compress tablepaces in SAPINST. Now I see that my source system have some tablespaces that are compressed with OLTP, but on my target system this is not the case.

Can I afterwards do something to make the source and target equal in compressed tablespaces?

It is on my DEV system. For the QAS and PRD I will be more alert when installing the target and doing the import. But for the DEV I need to fix this now with other methods in BRTOOLS or Oracle statements.

When I check in DB02 the tablespaces in the source and target, the compression options must be equal. How can I fix that?

SOURCE

TARGET

[Reagan · Accepted solution]

If you do not want to do an export and import (R3load based) again then the only option is to enable Oracle (ACO) compression on the target system using BR*Tools. 2138262 - Oracle Database 12c Advanced Compression for SAP Systems

[alicifci]

Thanks Reagan, in accordance with the customer I did'nt change anything.