Oracle Error ORA-14646: Specified alter table operation involving compression cannot be performed in the presence of usable bitmap indexes

Oracle Error Message

ORA-14646: Specified alter table operation involving compression cannot be performed in the presence of usable bitmap indexes

Reason for the Error

The first time a table is altered to include compression, it cannot have a usable bitmap index (partition). Subsequent alter table statements involving compression do not have this same restriction.

Solution

A) Drop any bitmap indexes defined on the table, and re-create them once the operation is complete or, B) Mark all index fragments of all bitmap indexes defined on the table UNUSABLE and rebuild them once the operation is complete.