Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


ORA-02403: plan table does not have correct format

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

More Oracle Errors Interview Questions

EXP-00058: Password Verify Function for string profile does not exist

1 Answers   MR,


RMAN-06560: WARNING: backup set with key number will be read number times

1 Answers  


KUP-03017: length specified for VARIABLE records must be greater than 0

1 Answers  


ORA-27155: could not execute file

1 Answers  


SQL*Loader-00420: unsupported datatype conversion requested for column string in table string

1 Answers  






ORA-24394: invalid mode for destroying connection pool

1 Answers  


LSX-00169: circular group reference is disallowed outside <redefine>

1 Answers  


QSM-02092: mv references a sequence number

1 Answers  


PCB-00210: DISPLAY-1 only allowed with PIC G and PIC N variables "string"

1 Answers  


LFI-01503: Max filename size exceeded generating filename.

1 Answers  


NNL-00546: Displays delete request statistics

1 Answers  


ORA-19663: cannot apply current offline range to datafile string

1 Answers  






Categories