Answer Posted / sravan kumar

If u get this error means u should create your own
plan_table and decleare it in your query.If u did that
means u will avoid ur problem.

ex: explain plan into plan_table(your own plan_table) for
query;

generally we use " explain plan for query " (In this query
oracle by default takes plan_table,in some situations it
shows error,by avoiding that errors we create plan_table
and menction as shown above)

ex:: explain plan into sravan for select * from emp e,dept
d where e.deptno=d.deptno;

ORA-16516: The current state is invalid for the attempted operation.

8871

---

when i ran any workflow or session, getting below error: seesion task instance[s_xxx]: Execution terminated unexpecterdly

2294

---

ORA-26076: cannot set or reset value after direct path structure is allocated

2027

---

ORA-26094: stream format error: input column overflow

2852

---

RMAN-05017: no copy of datafile number found to recover

2465

---

IMP-00063: Warning: Skipping table "string"."string" because object type "string"."string" cannot be created or has different identifier

2776

---

ORA-26084: direct path context already finished

1994

---

ORA-16627: No standby databases support the overall protection mode.

4036

---

ORA-26027: unique index string.string partition string initially in unusable state

6783

---

When i am connect database through toad,one error occured. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. plz help me thanks advance.............

2855

---

ORA-16626: failed to enable specified object

2268

---

if the lengths of two wires are same and the area of cross sections is 4:7 then what will be the ratio of current passing through these wires

2751

---

IMP-00064: Definition of LOB was truncated by export

6464

---

ORA-26032: index string.string loading aborted after string keys

2170

---

NZE-28890: Entrust Login Failed

1916

---