Hi All,
Long back we have created a subpartition table and we want to make it as compress table now . i have compressed all the subpartitions using below given command
"ALTER TABLE <TABLE_NAME> MOVE SUBPARTIITION <SUBPARTITION_NAME> COMPRESS FOR ALL OPERATIONS"
and my problem is whenever i add partitions to the table those partitions will not be come pressed . How to resolve this problem. pls suggest .
Thanks
Sree