Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-25229: error on transformation of message string string

1 Answers  


QSM-00802: An error occurred while implementing action string (string) string.

1 Answers  


ORA-14153: only one of STORE IN or <partition-description> clause may be specified

1 Answers  


ORA-28604: table too fragmented to build bitmap index (string,string,string)

1 Answers  


UDE-00002: invalid username or password

1 Answers  






ORA-16126: loading table or sequence string

1 Answers  


ORA-10653: Table is in a cluster

1 Answers  


ORA-08119: The new initrans will make the index too big

1 Answers  


ORA-14505: LOCAL option valid only for partitioned indexes

1 Answers  


QSM-00757: the specified workload string is not referenced by task string

1 Answers  


ORA-22152: destination variable-length array is not initialized

1 Answers  


DRG-12203: section group string does not exist

1 Answers   Four Design,






Categories