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

    Compress subpartition with pctfree


      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