ExplainPlan

This was a bug in TOAD 7.4.0.1. A patch was released (version 7.4.0.3). At the current time, TOAD 7.6 can be downloaded from Quest's website.

1. Check that the query you're "explaining" doesn't return that error.
2. TOAD 7.2 expected an Oracle 8i-compatible explain plan table.
3. TOAD 7.3 and higher should run Explain Plan correctly as long as your explain plan table is compatible with your database version. The 8i explain plan table has a few more columns than the Oracle 7 and 8.0 plan tables, and can be used just fine with those versions. The 9i explain plan table for TOAD has the same columns as the 8i plan table. In pre-7.5 versions of TOAD, use toadprep.sql to create an explain plan table that will be compatible with TOAD, or add the extra columns to the table you are already using. In TOAD 7.5 and higher, use the Server Side Objects wizard to create or update your plan table.