| how to use autotrace [message #54536] |
Wed, 20 November 2002 21:30  |
llz
Messages: 14
Registered: June 2002
|
Junior Member |
|
|
I create a table plan_table use utlexcpt.sql within
sys schema and I can set autrace on when I login on
as sys. But when I use other user to login, I can't
set autotrace, the error is
SP2-0613 :cannot verify Plan_Table formal or entity
SP2-0611 :it's error when start Explain report
Pls help, Thanks!
|
|
|
|
| Re: how to use autotrace [message #54537 is a reply to message #54536] |
Wed, 20 November 2002 21:55  |
gp
Messages: 46
Registered: September 2002
|
Member |
|
|
create the plan table in the schema u r trying to run he query to get explain plan...
another better way is to create plustrace role and grant it to other users !!!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
