欢迎光临
我们一直在努力

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. 更改完成后,可以重新启用位图索引。

赞(0)
【声明】:本博客不参与任何交易,也非中介,仅记录个人感兴趣的主机测评结果和优惠活动,内容均不作直接、间接、法定、约定的保证。访问本博客请务必遵守有关互联网的相关法律、规定与规则。一旦您访问本博客,即表示您已经知晓并接受了此声明通告。