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

TNS-00547: user information retrieval failed

1 Answers  


KUP-04073: record ignored because all referenced fields are null for a record

1 Answers  


ORA-29821: specified primary operator does not exist

1 Answers  


PLS-00411: Number of values in aggregate and in subquery don't match

1 Answers  


RMAN-06035: wrong version of recover.bsq, expecting string, found string

2 Answers  






ORA-30447: internal data for run number string is inconsistent

1 Answers  


TNS-01090: No longer listening on: string

1 Answers  


ORA-17508: I/O request buffer ptr is not alligned

1 Answers  


ORA-00224: controlfile resize attempted with illegal record type (string)

1 Answers  


ORA-02203: INITIAL storage options not allowed

1 Answers  


ORA-07281: slsget: times error, unable to get cpu time.

1 Answers  


TNS-00216: Total Failed Connections : number

1 Answers  


Categories