Click to See Complete Forum and Search --> : execution plan


salmanucit
11-23-2005, 01:32 PM
hi
i m using TOAD 8.5
when i want it to display execution plan for a query using SCOTT schema it gives me error

ORA-02404: specified plan table not found

i have created PLAN_TABLE in the scott schema and also in system schema and used different methods of this kind but still receiving error

kindly tell me how to use this option of TOAD

if i use SQLPLUs, PLAN_TABLE is working fine
Regards

Scorby
11-23-2005, 02:54 PM
By default, TOAD uses a plan table of a different name (TOAD_PLAN_TABLE). You can change this in the view/options/oracle in TOAD.

salmanucit
11-24-2005, 01:10 AM
thanks a lot dear