ORA-14646: Specified alter table operation involving
compression cannot be performed in the presence of usable
bitmap indexes
- 1 Answers
- 3328 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-19754: error reading from change tracking file
ORA-29279: SMTP permanent error: string
ORA-19706: invalid SCN
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
PLS-01714: ANSI expects a column name not a literal value here
NNL-00907: NOT ALLOWED responses sent: number
ORA-12722: regular expression internal error
ORA-21605: property [string] is not a property of value instances
ORA-12197: TNS:keyword-value resolution error
ORA-04011: sequence string must range between string and string
ORA-39136: cannot specify an SCN on a transportable job
ORA-06765: TLI Driver: error awaiting orderly release
Oracle Errors 
