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
- 4095 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 |
NNL-00036: No records loaded
DRG-13005: alt_value cannot be an NLS language name
NNO-00070: administrative region has changed, reloading domain data
ORA-12663: Services required by client not available on the server
ORA-01579: write error occurred during recovery
ORA-12592: TNS:bad packet
ORA-19726: cannot plug data [string] at level string into database running at compatibility level string
ORA-16209: Logical standby dictionary build failed to complete.
PLS-00410: duplicate fields in RECORD,TABLE or argument list are not permitted
NID-00303: Datafile string - wrote new name
ORA-29701: unable to connect to Cluster Manager
ORA-01930: auditing the object is not supported
Oracle Errors 
