When clicking the Explain Plan button in Editor the error message "ORA-00905 missing keyword" is displayed.
RESOLUTION1:
Make sure that you are running the explain plan on a single SQL statement. Explain plans cannot be created for multiple statements at one time or anonymous blocks.
RESOLUTION2:
You can't specify the PUBLIC schema for PLAN_TABLE in the View | Toad Options menu for explain plans. You have to leave the schema field blank.
RESOLUTION3:
Check that the TOAD_PLAN_TABLE exists in the schema. If not, either run the Server Side Objects Wizard to add it to the schema or create the table manually:
1. Run the attached script to create the TOAD_PLAN_TABLE
2. Go to menu View | Toad Options | Oracle | Gneral and add the schema name and TOAD_PLAN_TABLE under the schema
3. Click Apply | OK
