Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-14646: Specified alter table operation involving
compression cannot be performed in the presence of usable
bitmap indexes
- 1 Answers
- 4137 Views
- I also Faced
- E-Mail Answers
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 |
ORA-30353: expression not supported for query rewrite
ORA-02430: cannot enable constraint (string) - no such constraint
DRG-11218: malformed mail line, line string
ORA-32161: Cannot perform piecewise fetch
PLS-00317: incomplete type "string" was not completed in its declarative region
ORA-13027: unable to read dimension definition from string
TNS-12157: TNS:internal network communication error
O2F-00307: Unable to read the INTYPE file
ORA-12632: Role fetch failed
ORA-16576: failed to update Data Guard configuration file
ORA-13213: failed to generate spatial index for window object
ORA-10616: Operation not allowed on this tablespace
Oracle Errors 
