ORA-02404: specified plan table not found

Answers were Sorted based on User's Feedback



ORA-02404: specified plan table not found..

Answer / guest

Cause: The specified plan table does cannot be found.

Action: Create the specified plan table or use an existing
plan table.

Please add more information about this Error

Is This Answer Correct ?    3 Yes 3 No

ORA-02404: specified plan table not found..

Answer / tinskie

for toad users
1. run toadprep.sql
2. go to VIEW menu, click OPTIONS, click ORACLE in the tree
view, then change EXPLAIN PLAN TABLE NAME into PLAN_TABLE

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

NZE-29190: Multiple entries in OID

1 Answers  


PCC-02407: Object and REF types do not match

1 Answers  


ORA-29268: HTTP client error string

1 Answers  


RMAN-10004: unable to connect to recovery catalog

1 Answers  


ORA-25219: enqueue failed, sequence deviation not allowed for queue string.string

1 Answers  






PCC-00072: Input file name length exceeds the maximum length

1 Answers  


ORA-06751: TLI Driver: bound addresses unequal

1 Answers  


ORA-12833: Coordinator's instance not a member of parallel_instance_group

1 Answers  


LPX-00281: unsupported encoding "~s"

1 Answers  


ORA-39002: invalid operation

1 Answers  


ORA-36276: (XSCGMDLAGG06) Current operator does not need the weight variable.

1 Answers  


PLS-00204: function or pseudo-column 'string' may be used inside a SQL statement only

1 Answers  


Categories