Compress individual Table Partition with local Bitmap Indexes - ORA 14646
644807Jun 1 2010 — edited Oct 6 2010Hi all
I have an 11gR2 database set up on a LINUX box with a monthly date-range partitioned table TAB_X with two BITMAP indexes IDX_Y and IDX_Z .
I want to now individually compress an older date partition (April 2010), while keeping the current partition as uncompressed (May 2010). I followed the steps below:
1. alter index IDX_Y modify partition TAB_X_APR2010 unusable;
2. alter index IDX_Z modify partition TAB_X_APR2010 unusable;
3. alter table TAB_X move partition TAB_X_APR2010 tablespace NEW_TBS compress nologging parallel;
Step 3 above is throwing ORA 14646 error even though I have marked the two BITMAP indexes as unusable.
Question A) What am I doing wrong here?
Question B) Do I need to mark the entire indices UNSUABLE and not just the local index partitions with:
alter index IDX_Y unusable;
alter index IDX_Z unusable;
If so, wouldn't this also disable indexes for May 2010 table partition as well?