ORA-02402: PLAN_TABLE not found

Answer Posted / guest

Cause: The table used by EXPLAIN to store row source
information does not exist in the current schema.

Action: Create a plan table in the current schema or use the
INTO clause of the statement to put the results of the
explain command in an existing plan table.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

IMP-00096: Warning: Skipping table "string"."string" because type synonym "string"."string" cannot be created

1222


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

1457


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...

2243


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

1854


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

1735






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...

2123


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

1636


ORA-26028: index string.string initially in unusable state

3384


ORA-07497: sdpri: cannot create trace file 'string'; errno = string.

2299


ORA-26095: unprocessed stream data exists

2754


IMP-00060: Warning: Skipping table "string"."string" because object type "string"."string" does not exist or has different identifier

2602


IMP-00064: Definition of LOB was truncated by export

5864


IMP-00070: Lob definitions in dump file are inconsistent with database.

1268


ORA-26029: index string.string partition string initially in unusable state

1690


ORA-16626: failed to enable specified object

1750