ORA-14646: Specified alter table operation involving
compression cannot be performed in the presence of usable
bitmap indexes
Answer Posted / 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 View All Answers
ORA-26030: index string.string had string partitions made unusable due to:
ORA-16516: The current state is invalid for the attempted operation.
ORA-26032: index string.string loading aborted after string keys
if the lengths of two wires are same and the area of cross sections is 4:7 then what will be the ratio of current passing through these wires
ORA-07497: sdpri: cannot create trace file 'string'; errno = string.
IMP-00096: Warning: Skipping table "string"."string" because type synonym "string"."string" cannot be created
IMP-00063: Warning: Skipping table "string"."string" because object type "string"."string" cannot be created or has different identifier
ORA-26028: index string.string initially in unusable state
when i ran any workflow or session, getting below error: seesion task instance[s_xxx]: Execution terminated unexpecterdly
RMAN-05017: no copy of datafile number found to recover
IMP-00064: Definition of LOB was truncated by export
ORA-26094: stream format error: input column overflow
ORA-26027: unique index string.string partition string initially in unusable state
NZE-28868: Peer certificate chain check failed.
ORA-26082: load of overlapping segments on table string.string is not allowed