Answer / guest

Cause: The deleted table either had no key perserved tables,
had more than one key-preserved table, or the key-preserved
table was an unmerged view or a table from a read-only view.

Action: Redefine the view or delete it from the underlying
base tables.

Please add more information about this Error

NNL-00551: Displays cache statistics

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-24305: bad bind or define context

1 Answers  

---

PCB-00315: DECLARE TABLE is an Oracle extension

1 Answers  

---

ORA-16193: Primary and standby network encryption mismatch

1 Answers  

---

ORA-24387: Invalid attach driver

2 Answers  

---

TNS-04231: Trace Assistant WARNING: Assuming Oracle trace format

1 Answers  

---

PCB-00226: SQL identifier "string" already defined

1 Answers  

---

ORA-00377: Frequent backups of file string causing write operation to stall

1 Answers  

---

ORA-12442: policy column "string" already used by an existing policy

1 Answers  

---

NNF-00002: Invalid value passed to function call

1 Answers  

---

ORA-16790: The value of the configurable property is invalid

1 Answers  

---