Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-02403: plan table does not have correct format
- 2 Answers
- 7000 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 |
RMAN-08048: channel string: starting incremental level string datafile backupset
LPX-00266: invalid language specification ~s
ORA-06129: NETTCP: unable to transfer socket ownership to ORASRV
ORA-12544: TNS:contexts have different wait/test functions
ORA-29888: cannot create domain index on a table with row movement enabled
ORA-16513: maximum requests exceeded
ORA-19013: Cannot create VARRAY columns containing XMLType
DRG-11617: URL store: URL string is too long
ORA-01878: specified field not found in datetime or interval
ORA-07850: sllfop: bad option
ORA-06791: TLI Driver: poll returned error event
TNS-00293: Trace File Name : string
Oracle Errors 
