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 |
ORA-09918: Unable to get user privileges from SQL*Net
PLS-00609: the OVERRIDING clause is not valid for SQLJ Object Types
ORA-12486: effective max labels and min labels cannot be changed
ORA-14048: a partition maintenance operation may not be combined with other operations
ORA-01182: cannot create database file string - file is in use or recovery
ORA-06141: NETTCP: no privilege for user
NZE-28798: Number of sub-keys application passes to bind does not match that in the key.
ORA-38729: Not enough flashback database log data to do FLASHBACK.
DRG-50867: failed to free Oracle object
LSX-00104: duplicate type "~S"
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...
ORA-32406: cannot alter partitioning for existing materialized view log