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

SQL*Loader-00457: Comparison text of CONTINUEIF LAST must have length 1 not number

1 Answers  


ORA-22800: invalid user-defined type

1 Answers  


ORA-12551: TNS:missing keyword

1 Answers  


NZE-28837: no wallet descriptor

1 Answers  


RMAN-06043: TAG option not supported for archive log copies

1 Answers  






ORA-31523: could not find change source string for CDC change set string

1 Answers  


ORA-01514: error in log specification: no such log

1 Answers  


ORA-13386: commit/rollback operation error: [string]

1 Answers  


DRG-13303: value of wildcard offset must be in the range string..string, at line string

1 Answers  


TNS-12203: TNS:unable to connect to destination

1 Answers  


ORA-13333: invalid LRS measure

1 Answers  


TNS-01081: Started with pid=string

1 Answers  


Categories