ORA-14646: Specified alter table operation involving
compression cannot be performed in the presence of usable
bitmap indexes
- 1 Answers
- 3298 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-39142: incompatible version number string in dump file "string"
NNL-00894: Requests refused, permission denied: number
PCC-01009: For hostlan = COB74, a SQL statement must be followed by ELSE or "."
ORA-00357: too many members specified for log file, the maximum is string
ORA-36200: (XSAGGR34) AGGREGATE operator string requires a WEIGHTBY clause, but ARGS variable workspace object did not specify one.
RMAN-03029: echo set on
ORA-02706: osnshs: host name too long
SQL*Loader-00941: Error during describe of table string
ORA-29908: missing primary invocation for ancillary operator
TNS-04022: %s parameter string set to string.
ORA-31440: change set string is empty and cannot be advanced
PCC-01003: Invalid continuation at line number in file string
Oracle Errors 
