ORA-02403: plan table does not have correct format

Question Posted / guest

2 Answers
6177 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

ORA-02403: plan table does not have correct format..

Answer / guest

Cause: The explicit plan table does not have the appropriate
field definitions.

Action: Redefine the plan table to have the appropriate
field definitions.

Please add more information about this Error

Is This Answer Correct ?

0 Yes

0 No

ORA-02403: plan table does not have correct format..

Answer / 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;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer