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
- 4346 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-01743: only pure functions can be indexed
TNS-04078: Unable to resume atleast one of the gateways.
QSM-00802: An error occurred while implementing action string (string) string.
ORA-14500: LOCAL option not valid without partition name
ORA-00165: migratable distributed autonomous transaction with remote operation is not allowed
ORA-00260: cannot find online log sequence string for thread string
NNF-01008: XDS attribute syntax string incorrect for Oracle Names syntax string
ORA-06431: ssaio: Invalid Block number
RMAN-08008: channel string: starting full datafile backupset
ORA-14301: table-level attributes must be specified before partition-level attributes
QSM-01075: materialized view, string, does not support aggregate function, string
NNL-00214: Next auto-refresh for specified index number occurs in string
Oracle Errors 
