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

RMAN-08048: channel string: starting incremental level string datafile backupset

1 Answers  


LPX-00266: invalid language specification ~s

1 Answers  


ORA-06129: NETTCP: unable to transfer socket ownership to ORASRV

1 Answers  


ORA-12544: TNS:contexts have different wait/test functions

1 Answers  


ORA-29888: cannot create domain index on a table with row movement enabled

1 Answers  


ORA-16513: maximum requests exceeded

1 Answers  


ORA-19013: Cannot create VARRAY columns containing XMLType

1 Answers  


DRG-11617: URL store: URL string is too long

1 Answers  


ORA-01878: specified field not found in datetime or interval

1 Answers  


ORA-07850: sllfop: bad option

1 Answers  


ORA-06791: TLI Driver: poll returned error event

1 Answers  


TNS-00293: Trace File Name : string

1 Answers  


Categories