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

Question Posted / guest

1 Answers
4214 Views
I also Faced
E-Mail Answers

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-16513: maximum requests exceeded

1 Answers

ORA-28042: Server authentication failed

1 Answers

PCC-00122: Input file name and output file name are identical

1 Answers

ORA-29909: label for the ancillary operator is not a literal number

1 Answers

ORA-13153: invalid high water mark specified

1 Answers

ORA-29957: cannot create a function-based domain index on a string table

1 Answers

ORA-39108: Worker process string violated startup protocol. Worker error:

1 Answers

ORA-19610: directory block string is corrupt

1 Answers

NZE-28792: PL/SQL operation failure

1 Answers

ORA-04075: invalid trigger action

1 Answers

NZE-28827: invalid cipher type passed

1 Answers

ORA-29513: referenced class name too long

1 Answers

For more Oracle Errors Interview Questions Click Here