Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-02403: plan table does not have correct format
- 2 Answers
- 6907 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-16788: Unable to set one or more database configuration property values
ORA-07201: slhom: oracle_home variable not set in environment.
ORA-14290: PRIMARY KEY constraint mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION
ORA-19023: The first argument to UPDATEXML operator has to be an XMLTYPE
ORA-14306: List value 'string' specified twice in partitions 'string', 'string'
RMAN-06596: to use CONVERT compatibility must be set to 10.0.0 or greater, currently set to string
DRG-13304: character referenced by wildcard attribute is not a wildcard character, at line string
LPX-00007: unexpected end-of-file encountered
NPL-00308: requested ASN.1 class string does not match received class string
ORA-22913: must specify table name for nested table column or attribute
EXP-00081: Exporting access control for table/view "string" as non-DBA.
DRG-10561: index string is not valid for requested operation
Oracle Errors 
