Fix for TOAD error ORA-02404: specified plan table not found

Now moved to http://www.andrewfraserdba.com/?p=42

Advertisements

36 Responses to “Fix for TOAD error ORA-02404: specified plan table not found”

  1. Raj Says:

    Its absolutely good!!!!!!!
    Thanks alot for giving me a described solution for this error …

  2. Vivek Singh Says:

    Abolutely true good work!!!!!! keep posting

  3. David Landgren Says:

    I can confirm that the option 2 fix works for Toad 7.5 against a 10g database.

    I’ve been wondering about this for some time. I’ve been using Toad for ages on a 8.1.7 Oracle database, and since the beginning of this year I’ve been using it on a 10g database as well.

    The “Explain Plan” didn’t work in 10g and while I knew I should fix it I hadn’t had the need. This afternoon I finally needed to evaluate which of two selects was more efficient. Hence a web search that brought me to this page.

    In the process, the Explain Plan view helped me realise that I had forgotten a join between two tables which caused one of the statements to do a full table scan instead of an index scan. Yay!

  4. Nisha Says:

    Thanks , It worked

  5. Mario Says:

    Excelente!!! funcionó a la primera, muchas gracias.

    Saludos.
    Santiago, Chile.

  6. hans Says:

    it was required n i got it here, tks a lot

  7. Pb Says:

    thanks, it works :D

  8. Carla Says:

    This was just what I was looking for — thanks!

  9. Matt Says:

    Thanks for the info.

  10. Thomas Says:

    thank you for the working tip!

  11. Sunil Says:

    This one really works man. thanks a lot.

  12. aviana Says:

    Hi
    I tried the second option and it worked..
    now i can see explain plans.
    I didnt have a clue where to look for toadprep.sql…does anyone has a clue?

  13. instructions i got from help menu in Toad Says:

    To Load and Execute TOADPREP.SQL

    1. Connect as System or a DBA.

    2. Go to File > Open File.

    3. Open your TOAD > TEMPS folder.

    4. Double-click TOADPREP.SQL.

    5. The TOADPREP.SQL loads into your SQL Editor.

    6. Execute each statement in the script by clicking on the statement and pressing .

    If this is your first time running the TOADPREP.SQL script and you execute a Drop statement, you receive an error message. This is because there is nothing to drop. You can click OK and continue. However, you can just skip all the drop statements (don’t execute the drop statements), since TOAD has nothing to drop.

    7. For the Connect statement, you need to modify the statement for your connection.

    8. When you exit, TOAD will ask you if you want to save changes. Click Yes.

    Quest Software

  14. John Says:

    Thanks a lot for the solution, i really had good time.

  15. Mohan Says:

    I tried to fix my problem with the second option but it thrown me the following error message.

    The following files specified on the Executables tab could not be found:

    SQL*Loader

    Ping

    I appreciate your help. Thanks in advance.

  16. someshrocking Says:

    It Works !!! Thanks i appreciate your help

  17. Kanags Says:

    Great! Thanks a lot for sharing the tip.

  18. leo Says:

    thanks!!!

    i stumbled upon this link when googling. tried your suggestion, and it works great!
    thank you. this really helps.

  19. Anil Says:

    Great!! It’s working thanks for the help

  20. desmus Says:

    Bulls eye

  21. Onlyice Says:

    Thanks… helped in the right time…

  22. hari Says:

    thanks alottt…

  23. Ramesh Garikamokkala Says:

    Thanks a lot!!!!….Option 2 has worked out with out any errors….

  24. Thies Says:

    Thanks ! Why does Toad use its own plan table anyway..

  25. jose luis Says:

    Gracias, la segunda opción me funcionó a la perfección.

    Saludos.

  26. Itu Says:

    Thanks I am a new at using TOAD but I only spent a couple of second to apply the solution without a hitch. A very straight for ward answer and good explanation to the problem.

  27. Ajith KR Says:

    I tried the second option and it worked.
    Thanks guys.

  28. Raghavendra Says:

    It really worked. solution is stright to the point.
    thanks a lot for sharing the tips.

  29. Mahesh Says:

    This really worked for me .Thanks alot for providing this solution.Also please guide me to analyse this explain plan so as to optimise performance of the query.

  30. arun Says:

    I tried with the second option and it worked.
    Thank you

  31. Ayaz Says:

    Thanks a ton for valuable information. Really I appreciate your help

  32. KRRAJU Says:

    Thanks a lot it’s worked :)

    -Raju

  33. bhasker Says:

    Thanks .. The second one really worked for me

  34. Violet Says:

    thanks.. worked like a charm :)

  35. Ruchi Vipasa Says:

    Hey thanks a ton!! it worked.

  36. Monika Says:

    Thanks a lot it works

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: