This discussion is archived
9 Replies Latest reply: Feb 27, 2013 2:59 AM by Alessandro Suardi RSS

Compress subpartition with pctfree

706234 Newbie
Currently Being Moderated

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


  • Correct Answers - 10 points
  • Helpful Answers - 5 points