Return
-
Title
Where is the TOAD_PLAN_TABLE created in Toad for Oracle versions 9.x and after? -
Description
Where is the TOAD_PLAN_TABLE created in Toad for Oracle versions 9.x and after?
It used to be an option in the Server Side Objects Wizard of earlier versions, but is no longer there in more recent releases. Having run Server Side Objects in version 9.x, the table is not showing in the Schema Browser. -
Resolution
In order to create the TOAD_PLAN_TABLE, please follow these steps:
1. Go to: View | Toad Options | Oracle | General
2. Find the Explain Plan section
3. Click the ... button to specify the schema you want to create the table in.
4. Press OK
Refresh the Schema Browser for the specified schema, and the TOAD_PLAN_TABLE table will now exist.