9 Replies Latest reply: Feb 27, 2013 4:59 AM by Alessandro Suardi-Oracle RSS

    Compress subpartition with pctfree

    user837363
      Hi,

      how to compress subpartition on exadata, using 'for query high' and pctfree 10 options?

      I used this statment, but I get only ORA-14160:this physical attribute may not be specified for a table subpartition.

      alter table table_name move subpartition subpartition_name PCTFREE 10 compress for query high;

      Edited by: user837363 on 2012-11-12 05:14