Oracle Database Discussions

Hi,

I need to change compression type on the table from BASIC to COMPRESS FOR QUERY.

I successeded to change it at the partition level :

alter table XYZ modify partition SYS_P44 compress for query ;

But also need to change compression type at table definition:

SQL> select def_compress_for
  2  from DBA_PART_TABLES
  3  where table_name='CM_CUST_DIM_INST_PROD'
  4  /

DEF_COMPRESS
------------
BASIC

Trying the following option raise an error.

alter table XYZ  modify DEFAULT ATTRIBUTES DEF_COMPRESS_FOR  compress for query;

ERROR at line 1:
ORA-14121: MODIFY DEFAULT ATTRIBUTES may not be combined with other operations

Please advice