Table compression in 11gR2 Databases and Exadata

If you need to create a compress table for an OLTP system use the syntax below:

create table TAB_1(
col1 number,
col2 varchar2(30))
COMPRESS FOR OLTP;

If you need to create a compress table for Direct Load use the command below:

create table TAB_2 (
col1 number,
col2 varchar2(30))
COMPRESS BASIC;


Now you want to compress for Exadata Machine. For warehouse compression use:

CREATE TABLE tab_1 (
col1 number,
col2 varchar2(30))
COMPRESS FOR QUERY [ LOW | HIGH ] ;

For Online Archival Compression use:

CREATE TABLE tab_1 (
col1 number,
col2 varchar2(30))
COMPRESS FOR ARCHIVE [ LOW | HIGH ] ;


Best Regards,
Paulo Portugal