OracleAppsDNA

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

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 🙂

Exit mobile version