Oracle Database Discussions

Hi All,

I am facing a problem while compressing the partitioned table which is sub partitioned.
i have done following steps.

1. First i have compressed the Sub partitions of table.Blow given are the command with i have used for compressing.

ALTER TABLE sales
MOVE subPARTITION P_20121220_US
COMPRESS FOR ALL OPERATIONS;

and i checked in user_tab_subpartitions tables and the sub partitions are compresssed.

But the partitions has not been compressed after doing sub partition compression.
Do i need to compress at partition level since i have already done the compression for Sub partition level.

please any one suggest me.


Thanks
Sree