cancel
Showing results for 
Search instead for 
Did you mean: 

how to perform Advanced Row Compression of tables with brspace command

SAPSupport
Employee
Employee
0 Kudos
547

How to perform Advanced Row Compression of tables with brspace command in order to achieve the below advantage as per sapnote 2138262
To compress existing data a table
reorg should be performed by BRSPACE.


------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

Accepted Solutions (1)

Accepted Solutions (1)

SAPSupport
Employee
Employee
0 Kudos

Dear Customer,

Please use below command from note 2138262 to set the advanced row compression:

SQL> ALTER TABLE COEP (...) ROW STORE COMPRESS ADVANCED;

For the already existing data in the table please perform a reorganization.

2138262 - Oracle Database 12c Advanced Compression for SAP Systems
646681 - Reorganization of tables with BRSPACE

Answers (0)