ORA-14646: Specified alter table operation involving compression cannot be performed in the presence of usable bitmap indexes ORACLE 报错 故障修复 远程处理

文档解释

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

Cause: 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.

Action: 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.

ORA-14646：指定的对表进行改变的操作包括压缩，在出现可用的位图索引的情况下不能完成。

官方解释

常见案例

正常处理方法及步骤

1. 检查表上的位图索引，看看是否可用。

2. 如果可用，需要将位图索引失效，然后执行alter table语句。

3. 更改完成后，可以重新启用位图索引。