重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: ORA-14646: Specified alter table operation involving [打印本页]

作者: admin    时间: 2016-8-21 11:09
标题: ORA-14646: Specified alter table operation involving
ORA-14646: Specifiedalter table operation involving compression cannot be
performed in the presence of usable bitmap indexes
Cause:
The first time a table is altered to includecompression, 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.







欢迎光临 重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/) Powered by Discuz! X3.2