ORA-14646: Specified alter table operation involving
compression cannot be performed in the presence of usable
bitmap indexes
- 1 Answers
- 3516 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-37026: (XSMLTRESYNC01) Object workspace object cannot be resynced without dimension workspace object.
ORA-08270: sksachk: Illegal archival control string
PLS-00611: right hand side can be only the variables of record type
NNF-04001: Error converting input file
ORA-16174: user requested thread/sequence termination of managed recovery
DRG-10762: index owner does not have access to procedure string
TNS-04211: Trace Assistant Internal ERROR: CORE
QSM-02042: view or subquery in from list
ORA-08206: ora_addr: cannot translate address file name
ORA-24075: cannot specify agent with NULL address and non-NULL protocol
ORA-27156: request for process information failed
RMAN-07521: cannot create recovery catalog in database version string; version string required
Oracle Errors 
