ORA-08111: a partitioned index may not be coalesced as a whole



ORA-08111: a partitioned index may not be coalesced as a whole..

Answer / guest

Cause: User attempted to coalesce a partitioned index using
ALTER INDEX COALESCE statement, which is illegal

Action: Coalesce the index a (sub)partition at a time (using
ALTER INDEX MODIFY (sub)PARTITION COALESCE)

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-16008: indeterminate control file checkpoint

1 Answers  


ORA-25131: cannot modify unique(string) - unique key not defined for table

1 Answers  


DRG-12410: could not process CTX EXEC tag

1 Answers  


ORA-00122: cannot initialize network configuration

1 Answers  


ORA-10574: Test recovery did not corrupt any data block

1 Answers  






ORA-23402: refresh was aborted because of conflicts caused by deferred txns

1 Answers  


ORA-00394: online log reused while attempting to archive it

1 Answers  


ORA-25402: transaction must roll back

1 Answers  


TNS-01060: The password has has been set to: string

1 Answers  


ORA-09833: addCallback: bad message format.

1 Answers  


ORA-07483: snlkget: cannot convert(get) lock.

1 Answers  


ORA-29824: operator is invalid

1 Answers  


Categories