[TOAD Error] Specified Plan Table not Found while trying to see Explain Plan of a Query

By | July 27, 2011

TOAD can report error “ORA-02404: specified plan table not found” when trying to display execution plans

To come out of this problem

In TOAD, Navigate to  View -> Options -> Oracle  then change the Explain Plan Table name to “PLAN_TABLE”, removing the “TOAD_” from the beginning.

Reference: www.andrewfraserdba.com Thanks to Andrew Fraser 🙂

WOW! Did you like this post? We'll send more interesting posts like [TOAD Error] Specified Plan Table not Found while trying to see Explain Plan of a Query to you!
Enter your Email Address: