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

PLS-01907: : number precision too large

1 Answers

QSM-01066: materialized view, string, does not have the column, string, from query

1 Answers

ORA-15093: buffer only contains string bytes, I/O requested is string bytes

1 Answers

LSX-00152: only "minOccurs", "maxOccurs", or "id" is allowed

1 Answers

ORA-13413: null or invalid resampling parameter

1 Answers

ORA-37042: (XSACQUIRE_DEP_DEADLOCK) Cannot wait to acquire composite, concat, dimension map, or internal partition workspace object since doing so would cause a deadlock.

1 Answers

ORA-31165: cannot load object-relational XML attribute using direct path

1 Answers

ORA-06564: object string does not exist

1 Answers

ORA-02288: invalid OPEN mode

1 Answers

NNL-00513: Shows or sets the server's auto-refresh failure retry interval

1 Answers

IMP-00082: Error during conversion ROWID from string format to internal

1 Answers

ORA-16794: Database Guard is ON for primary database

1 Answers

For more Oracle Errors Interview Questions Click Here