oracle 11gr2 deduplication or compression feature

[Former Member]

Hi All;

The Oracle Database will be upgraded from current 9i to 11G for SAP .Does SAP support the Compression or deduplication feature which is used while creating the objects within the database.

Secondly, is the compression or deduplication feature is allowed for the existing objects within the database system.?

Thirdly, is the compression or deduplication feature is applicable in future for new objects .?

Kindly provide a reply

Regards

Ram

[Former Member · Accepted solution]

Absolutely yes for all three questions

[1436352 - Oracle 11g Advanced Compression for SAP Systems|https://service.sap.com/sap/support/notes/1436352]

[1289494 - FAQ: Oracle compression|https://service.sap.com/sap/support/notes/1289494]

Cheers Michael

[Former Member]

Hi Ram,

The Oracle Database will be upgraded from current 9i to 11G for SAP .Does SAP support the Compression or deduplication feature which is used while creating the objects within the database.

A. Both table and index compression are supported by SAP on Oracle 11g.

Secondly, is the compression or deduplication feature is allowed for the existing objects within the database system.?

A. It is allowed to compress the existing objects.

Thirdly, is the compression or deduplication feature is applicable in future for new objects .?

A. Yes, you can have the option enabled for the new objects to be created.

Refer: Note 1289494 - FAQ: Oracle compression and Note 1436352 - Oracle 11g Advanced Compression for SAP Systems

Br,

Venky