Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-02403: plan table does not have correct format
- 2 Answers
- 6948 Views
- I also Faced
- E-Mail Answers
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-21608: duration is invalid for this function
ORA-00088: command cannot be executed by shared server
ORA-09856: smpalo: vm_allocate error while allocating pga.
ORA-39111: Dependent object type string skipped, base object type string already exists
ORA-31115: XDB configuration error: string
ORA-16082: logical standby is not initialized correctly
NNL-00226: Current request-processing delay is string
ORA-16802: downgrading log transport mode from SYNC disallowed
RMAN-06463: Backup set key string cannot be backed up by proxy.
PLS-00662: Non-external object types containing external mapped attributes are not allowed
LPX-00201: unknown encoding "~s"
ORA-31204: DBMS_LDAP: PL/SQL - Invalid LDAP Session.
Oracle Errors 
