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-37112: OLAP API requires Oracle 9.2 or later
LFI-01507: fwrite() failed(OSD return value = string) in string.
RMAN-08587: input is copy of datafile string: string
ORA-19586: %s k-byte limit is too small to hold piece directory
ORA-01648: log string is the current log of disabled instance string (thread string)
ORA-02491: missing required keyword ON or OFF in AUTOEXTEND clause
ORA-25014: cannot change the value of a PARENT reference variable
ORA-38604: FI including & excluding cursor item-id type must match input cursor item-id type
ORA-12612: TNS:connection is busy
PCB-00008: Must use option SQLCHECK=SEMANTICS(FULL) when there is embedded PL/SQL
ORA-12549: TNS:operating system resource quota exceeded
LPX-00243: element attribute value must be enclosed in quotes