DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: execution plan

  1. #1
    Join Date
    Jul 2004
    Location
    Pakistan
    Posts
    46

    execution plan

    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
    Salman Ahmed Qureshi
    Lahore, Pakistan

  2. #2
    Join Date
    Nov 2001
    Location
    UK
    Posts
    152
    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.

  3. #3
    Join Date
    Jul 2004
    Location
    Pakistan
    Posts
    46
    thanks a lot dear
    Salman Ahmed Qureshi
    Lahore, Pakistan

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width