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 |
RMAN-05007: no channel allocated
RMAN-06430: recovery catalog userid cannot be SYS
ORA-32800: internal error string
ORA-02471: SYSDATE, UID, USER, ROWNUM, or LEVEL incorrectly used in hash expre\ssion.
ORA-02048: attempt to begin distributed transaction without logging on
ORA-12550: TNS:syntax error
TNS-12164: TNS:Sqlnet.fdf file not present
RMAN-06520: archived logs required to recover from this backup will not be kept
PLS-00924: native compilation is not supported on this platform
UDI-00051: unable to set NLS_NUMERIC_CHARACTERS to required defaults.
ORA-29849: error occurred in the execution of ODCIINDEXSPLITPARTITION routine
ORA-30736: objects in a table or view hierarchy have to be in the same schema