Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


ORA-02403: plan table does not have correct format

Answers were Sorted based on User's Feedback



ORA-02403: plan table does not have correct format..

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

ORA-02403: plan table does not have correct format..

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

Post New Answer

More Oracle Errors Interview Questions

ORA-37112: OLAP API requires Oracle 9.2 or later

1 Answers  


LFI-01507: fwrite() failed(OSD return value = string) in string.

1 Answers  


RMAN-08587: input is copy of datafile string: string

1 Answers  


ORA-19586: %s k-byte limit is too small to hold piece directory

1 Answers  


ORA-01648: log string is the current log of disabled instance string (thread string)

1 Answers  


ORA-02491: missing required keyword ON or OFF in AUTOEXTEND clause

1 Answers  


ORA-25014: cannot change the value of a PARENT reference variable

1 Answers  


ORA-38604: FI including & excluding cursor item-id type must match input cursor item-id type

1 Answers  


ORA-12612: TNS:connection is busy

1 Answers  


PCB-00008: Must use option SQLCHECK=SEMANTICS(FULL) when there is embedded PL/SQL

1 Answers  


ORA-12549: TNS:operating system resource quota exceeded

1 Answers  


LPX-00243: element attribute value must be enclosed in quotes

1 Answers  


Categories