How do I move the Explain Plan table to a different tablespace using Toad?
说明
How do I move the Explain Plan table (by default called, TOAD_PLAN_TABLE ) to a different tablespace using Toad?
解决办法
1. Drop the existing TOAD_PLAN_TABLE from the schema that owns it. You can use the Schema Browser and right-click to drop it. 2. Drop the existing TOAD_PLAN_TABLE public synonym from the PUBLIC schema. Again, you can use the Schema Browser to do it. 3. Go to View | Toad Options | Oracle | General. 4. On the right pane notice Explain Plan box. 5. Click on the ellipses box (... box). In Toad 9.0, the icon is a flashlight. 6. When asked "Plan table exists. Do you want to keep it as your selection?" click "No." 7. In the "Create/Use Another Pan Table," notice that there is a field for you to select the tablespace. Click on the ellipses box to make your tablespace selection.