Oracle Database Errors or Warnings from Error ORA-08111 to ORA-08120



ORA-08111: a partitioned index may not be coalesced as a whole
Cause: User attempted to coalesce a partitioned index using ALTERR INDEX COALESCEE statement, which is illegal
Action: Coalesce the index a (sub)partition at a time (using ALTERR INDEX MODIFY (sub)PARTITIONN COALESCEE)
ORA-08112: a composite partition may not be coalesced as a whole
Cause: User attempted to coalesce a composite partition
Action: Coalesce the index a subpartition at a time (using ALTERR INDEX MODIFYY SUBPARTITIONN COALESCEE)
ORA-08113: composite partition index may not be compressed
Cause: User attempted to compress a composite partition index
Action: create uncompressed composite partition index

ORA-08114: can not alter a fake index
Cause: User attempted to alter a fake index
Action: drop fake index
ORA-08115: can not online create/rebuild this index type
Cause: User attempted to create index type that online doesnot support
Action: use offline index create/rebuild command
ORA-08116: can not acquire dml enough lock(S mode) for online index build
Cause: User attempted to createe index online without allowing DML Share lock
Action: allow DML share lock on the base table
ORA-08117: Index Organized Table operation released its block pin
Cause: Block maintenance forced the release of a block pin

Action: Contact your customer support representative
ORA-08118: Deferred FK constraints cannot be enforced, index too big (string)
Cause: Deferred Foreign Key constraints cannot be enforced due to the index key being too big and built on a non-default DB_BLOCK_SIZEE.
Action: First try to drop the Foreign Key and then the primary key.
ORA-08119: The new initrans will make the index too big
Cause: Specifying the initrans need additional space to hold the index key which might make the index too big
Action: Try giving a smaller initrans value
ORA-08120: Need to create SYS.IND_ONLINEE$ table in order to (re)build index
Cause: Alterr index Build/Rebuild online require existing of SYS.IND_ONLINEE$ table.
Action: User/DBA needs to create sys.ind_online$ before alter the index /rdbms/admin/catcio.sql contains script to create ind_onlinee$.


Above are list of Oracle Database Errors or Warnings from Error ORA-08111 to ORA-08120 received while performing certain operation against Oracle Database or related products.

What are Oracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database.  Each Oracle Database Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.


Leave a Reply

Your email address will not be published. Required fields are marked *