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

DRG-11526: filename exceeds maximum length

1 Answers  


QSM-02030: reduced precision specified for prebuilt mv

1 Answers  


RMAN-04009: WARNING from auxiliary database: string

1 Answers  


ORA-14192: cannot modify physical index attributes of a Hash index partition

1 Answers  


SQL*Loader-00821: switching to GENERATE_ONLY

1 Answers  






ORA-06503: PL/SQL: Function returned without value

1 Answers  


NNO-00260: loading configuration data from checkpoint file "string"

1 Answers  


ORA-29300: ORACLE error, tablespace point-in-time recovery

1 Answers  


PLS-00133: Pragma string expects 1st argument to be an identifier or string-literal

1 Answers  


ORA-22130: buffer size [string] is less than the required size [string]

1 Answers  


PCC-02012: did not find matching quote for char constant

1 Answers  


PROC-00027: Error in authentication layer

1 Answers  


Categories