Oracle® Database 8i | 9i | 10g | 11g | 12c | 18c | 19c Error Codes

Information for Database Error Code ORA-14646: Specified alter table operation involving compression cannot be performed in the presence of usable bitmap indexes
Oracle® Database Error ORA-146461132/15

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.

Error Type: ORA

Oracle® Database Error Codes 8i | 9i | 10g | 11g | 12c | 18c | 19c

Record: 1/1

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners

Oracle: Registered trademark of Oracle