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
- 4132 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-25104: UNRECOVERABLE option can only be used with ALTER INDEX REBUILD
ORA-28664: a partitioned table may not be coalesced as a whole
ORA-00392: log string of thread string is being cleared, operation not allowed
ORA-22297: warning: Open LOBs exist at transaction commit time
ORA-09927: Unable to set label of server
ORA-07743: slemop: incorrect error file attributes
ORA-34279: (MXDCL37) CONCAT can only be used when defining a DIMENSION.
ORA-00105: too many dispatcher configurations
TNS-00087: * version - ask the process name to display its version number
PCB-00702: Out-of-range item number
ORA-33078: (XSAGDNGL39) In AGGMAP workspace object, the hierarchy dimension QDR workspace object must refer to a dimension.
ORA-06802: TLI Driver: could not open the /etc/netware/yellowpages file
Oracle Errors 
