ORA-02403: plan table does not have correct format
Answers were Sorted based on User's Feedback
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 |
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 |
ORA-31068: updateXML expected data format [string] instead of [string]
DRG-12433: load of string JDBC driver class failed
PCC-00105: Keyword WORK required here by ANSI
ORA-24027: AQ HTTP propagation encountered error, status-code string, string
ORA-27013: skgfqdel: cannot delete an open file
SQL*Loader-00905: Error parsing SQL statement for upi: [number]
RMAN-08508: archive log destination=string
ORA-00329: archived log begins at change string, need change string
ORA-29383: all leaves of top-plan string must be consumer groups
ORA-26575: remote database does not support replication parallel propagation
ORA-06536: IN bind variable bound to an OUT position
SQL*Loader-00465: %s directive expects number arguments, number found.