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
- 4242 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 |
NCR-00003: NCR: Initialization failure
IMP-00048: mismatched file header
CLSR-00504: Error number encountered when posting an EVM event
ORA-02471: SYSDATE, UID, USER, ROWNUM, or LEVEL incorrectly used in hash expre\ssion.
SQL*Loader-00803: %s field type not supported by External Table
ORA-01059: parse expected before a bind or execute
ORA-02353: files not from the same unload operation
TNS-12571: TNS:packet writer failure
PLS-00140: duplicate external LIBRARY specification in subprogram expression
ORA-36635: (XSDUNION03) The base dimension workspace object has an invalid datatype for use in a UNIQUE concat definition.
ORA-14045: only one partition may be modified
ORA-09876: TASDEF_CLOSE: unable to close ?/dbs/tasdef@.dbf file.
Oracle Errors 
