ORA-08116: can not acquire dml enough lock(S mode) for
online index build



ORA-08116: can not acquire dml enough lock(S mode) for online index build..

Answer / guest

Cause: User attempted to create index online without
allowing DML Share lock

Action: allow DML share lock on the base table

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-29864: analyzing domain indexes marked LOADING/FAILED not supported

1 Answers  


ORA-14296: Table block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION

1 Answers  


PLS-00706: Exception string cannot be used as prefix of a selected component

1 Answers  


ORA-12607: TNS: Connect timeout occurred

1 Answers  


ORA-15192: invalid ASM disk header [string] [string] [string] [string] [string]

1 Answers  






ORA-00208: number of controlfile names exceeds limit of string

1 Answers  


ORA-26675: cannot create Streams capture process string

1 Answers  


ORA-30689: improper value for ORA_DEBUG_JDWP

1 Answers  


QSM-01125: a more optimal set operator materialized view than string was used to rewrite

1 Answers  


ORA-02278: duplicate or conflicting MAXVALUE/NOMAXVALUE specifications

1 Answers  


ORA-37104: (XSVPART04) A partitioned variable must be dimensioned by a single partition template only.

1 Answers  


ORA-30157: An invalid argument was given to operating system call

1 Answers  


Categories