Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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



ORA-14646: Specified alter table operation involving compression cannot be performed in the presenc..

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-31057: Display Name of the element being inserted is null

1 Answers  


PLS-00510: Float cannot have scale

1 Answers  


NNC-00416: user callback function returned error number string

1 Answers  


ORA-24430: Null values for sqltext and key were specified.

1 Answers  


ORA-06925: CMX: disconnect during connect request

1 Answers  






PCC-02358: Identifier following ARRAYLEN must be the name of an array

1 Answers  


ORA-19672: media management software returned invalid file status

1 Answers  


ORA-16123: transaction string string string is waiting for commit approval

1 Answers  


ORA-40211: algorithm name string is invalid

1 Answers  


RMAN-12005: error during channel cleanup

1 Answers  


LSX-00282: duplicate notation name "~S"

1 Answers  


LPX-00110: invalid ~1s "~2S" (not a Name)

1 Answers  






Categories