Answer / guest

Cause: Import failed to create an object because it already
exists.

Action: Specify IGNORE=Y to ignore such errors and import
rows even when tables are not created because they already
exist.

Please add more information about this Error

QSM-02011: a HAVING clause is present

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-22926: specified trim length is greater than current LOB value's length

1 Answers  

---

NZE-29233: the key object could not be encoded

1 Answers  

---

ORA-24906: invalid recepient attribute passed into OCI call

1 Answers  

---

TNS-04077: WARNING: No password set for the Oracle Connection Manager instance.

1 Answers  

---

O2F-00333: An unexpected token appeared where a keyword was expected in the INTYPE file

1 Answers  

---

IMG-00830: boundary queue is full

1 Answers  

---

ORA-01799: a column may not be outer-joined to a subquery

1 Answers  

---

ORA-12403: invalid internal label

1 Answers  

---

ORA-27214: skgfrsfe: file search failed

1 Answers  

---

ORA-09813: Unable to get directory status

1 Answers  

---