How to solve Oracle Database Error 8111 (ora-08111)

Oracle Error Code
   ora-08111

Description
   a partitioned index may not be coalesced as a whole

Cause
   User attempted to coalesce a partitioned index using ALTER INDEX COALESCE statement, which is illegal
How to Solve
   Coalesce the index a (sub)partition at a time (using ALTER INDEX MODIFY (sub)PARTITION COALESCE)

Do you have question or do you know about solution ?

Share with us. (No registration required)
  
Your Name
Question, comment or solution
Similar Errors
  ORA-08100    ORA-08101    ORA-08102    ORA-08111    ORA-08112    ORA-08113    ORA-08114  Others

Main Page      Contact Us      Tools & Softwares      Server Monitoring Softwares