Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-02403: plan table does not have correct format
- 2 Answers
- 6902 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-12351: cannot create view using a remote object which has a remote object reference
ORA-02440: Create as select with referential constraints not allowed
IMG-00560: input format does not support page selection
PLS-00592: the type of a object table must be an object type
QSM-00779: the specified directive conflicts with the existing directive string
ORA-12811: PARALLEL_MIN_SERVERS must be less than or equal to PARALLEL_MAX_SERVERS, string
NNO-00626: cannot enable DEFAULT-FORWARDERS-ONLY mode, no default forwarders exist
ORA-29866: cannot create domain index on a column of index-organized table
NZE-28765: Data method list does not exist.
RMAN-06507: trying alternate file for archivelog thread number, sequence number
ORA-12622: TNS:event notifications are not homogeneous
CLSR-01010: Unable to record PMON pid to string
Oracle Errors 
