How to compress index subpartitions?
Hi Everyone,
We have have a table with 17 partition and all togather 136 subpartitions.
When I issued:
alter index ORDER_PROC_PAID_CMP rebuild partition P2 compress; I got ORA-14287,
I then try to compress one partition at a time by:
alter index ORDER_PROC_PAID_CMP rebuild subpartition SP1 compress;, I got ORA-14189.
What is the correct syntacs to achieve the compression?
Do I need alter index moveafter the compression succeed like compression of table subpartition?
Thanks.
Yinhai
We have have a table with 17 partition and all togather 136 subpartitions.
When I issued:
alter index ORDER_PROC_PAID_CMP rebuild partition P2 compress; I got ORA-14287,
I then try to compress one partition at a time by:
alter index ORDER_PROC_PAID_CMP rebuild subpartition SP1 compress;, I got ORA-14189.
What is the correct syntacs to achieve the compression?
Do I need alter index moveafter the compression succeed like compression of table subpartition?
Thanks.
Yinhai
0