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-09918: Unable to get user privileges from SQL*Net

1 Answers  


PLS-00609: the OVERRIDING clause is not valid for SQLJ Object Types

1 Answers  


ORA-12486: effective max labels and min labels cannot be changed

1 Answers  


ORA-14048: a partition maintenance operation may not be combined with other operations

1 Answers  


ORA-01182: cannot create database file string - file is in use or recovery

1 Answers  


ORA-06141: NETTCP: no privilege for user

1 Answers  


NZE-28798: Number of sub-keys application passes to bind does not match that in the key.

1 Answers  


ORA-38729: Not enough flashback database log data to do FLASHBACK.

1 Answers  


DRG-50867: failed to free Oracle object

1 Answers  


LSX-00104: duplicate type "~S"

1 Answers  


Hi guys, I have four tables those are emp,dept,eliminate and uneliminate. i wrote small cursor..when i run, it display one error (ORA-01403 nodata found)... The query is: Declare cursor c1 is select e.ename emp_name from emp e,dept d where e.deptno=d.deptno group by deptno; r1 c1%rowtype; test_emp varchar2(200); begin for r1 in c1 loop begin select eliminate_emp into test_emp from eliminate t,uneliminate ut where t.number=ut.number and t.deptno=e.deptno and rownum<1; end; dbms_output.put_line(r1.emp_name); end loop; end; Thanks...

0 Answers   IBM,


ORA-32406: cannot alter partitioning for existing materialized view log

1 Answers  


Categories