Answer / guest

Cause: A thread's current log cannot be dropped even if the
thread is closed. A disabled thread usually does not have a
current log, but a half completed disable may need to be
disabled again.

Action: If the database is not open then disable the thread.
If the database is open and an instance has the thread open,
then the instance can be requested to switch logs. If the
database is closed the log can be archived or cleared to
force a switch.

Please add more information about this Error

TNS-04076: Invalid specification for state.

1 Answers  

---

ORA-31052: Cannot delete ACL with other references

1 Answers  

---

NNL-00275: Trace level is currently number

1 Answers  

---

NNL-00544: Displays operations statistics

1 Answers  

---

ORA-01689: syntax error in clause "string" of string

1 Answers  

---

ORA-16742: The standby "string" has used up its quota.

1 Answers  

---

ORA-26080: file "string" is not part of table string.string partition string

1 Answers  

---

ORA-13797: invalid SQL Id specified, string

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,

---

QSM-02123: subquery and UNION mv's must be primary key mv's

1 Answers  

---

ORA-12913: Cannot create dictionary managed tablespace

1 Answers  

---

RMAN-06088: datafile copy string not found or out of sync with catalog

1 Answers  

---