SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Index compression on a subpartitioned table

sql_devMar 29 2016 — edited Mar 29 2016

Hi All,

I am using Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production.

I am trying to compress an index on a sub-partition but not able to compress. The table OV_CALC_FACT is a composite partitioned table. Tried doing at partition level/sub-partition level, but still couldn't get to it. Please let me know or share some links to achieve this.

alter index OV_CALC_FACT_IDX5 rebuild partition P_20160128 compress;

ORA-14287: cannot REBUILD a partition of a Composite Range partitioned index

alter index OV_CALC_FACT_IDX5 rebuild subpartition P_20160128_GMIP compress;

ORA-14189: this physical attribute may not be specified for an index subpartition

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 26 2016

Added on Mar 29 2016

2 comments

536 views