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
4136 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

RMAN-06541: tablespace string will be included in future whole database backups

1 Answers

ORA-24763: transaction operation cannot be completed now

1 Answers

SQL*Loader-00560: error reading file

1 Answers

ORA-06730: TLI Driver: unable to open clone device

1 Answers

ORA-04080: trigger 'string' does not exist

1 Answers

ORA-02723: osnpui: cannot send break signal

1 Answers

ORA-38455: Expression Filter index should be created by the owner.

1 Answers

RMAN-08531: channel string: proxy copy string is string in media management catalog

1 Answers

ORA-36204: (XSAGOP04N) In AGGMAP workspace object, the NAOPERATOR string must be HFIRST, HLAST or HEVEN.

1 Answers

ORA-25408: can not safely replay call

2 Answers

ORA-12552: TNS:operation was interrupted

1 Answers

ORA-28132: Merge into syntax does not support security policies.

2 Answers

For more Oracle Errors Interview Questions Click Here