Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-02403: plan table does not have correct format
- 2 Answers
- 7004 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 |
LSX-00021: undefined element "~S"
ORA-22933: cannot change object with type or table dependents
IMP-00012: invalid export mode (character) in header
NNL-00931: Requests refused, no cached meta-data: number
PCB-00238: Element of this table group item host variable cannot be a table
RMAN-06708: short write while writing file "string". Wrote string bytes instead of string bytes
ORA-07208: sfwfb: failed to flush dirty buffers to disk.
DRG-12231: an attr section named string already exists in this section group
ORA-01952: system privileges not granted to 'string'
RMAN-06583: at least 1 channel of TYPE DISK must be allocated to use AS COPY option
PCC-02394: Input file name and output filename are identical
PLS-00334: "string" matches table or view without an alias
Oracle Errors 
