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
- 4349 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 |
NNO-00072: loading from region database
NNL-00346: Save_config_on_stop is now ON
ORA-32107: internal OCI memory allocation failure
TNS-00104: Data stream open/access error
ORA-09787: sllfop: unrecognizable processing option, incorrect format.
ORA-24352: invalid COBOL display type passed into OCI call
ORA-01684: max # extents (string) reached in table string.string partition string
RMAN-08102: channel string: located backup piece: string
ORA-38611: FI input cursor's item type is not supported
ORA-29546: badly formed resource: string
NNL-00908: UNKNOWN TYPE responses sent: number
TNS-00034: INTCTL: internal NR error
Oracle Errors 
