Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: no able to "set autotrace on" pls chk error
> SQL> create user dump identified by dump;
> User created.
>
> SQL> grant connect,resource to dump;
> Grant succeeded.
>
> SQL> conn dump/dump_at_y2j
> Connected.
> SQL> @c:\oracle\ora90\rdbms\admin\utlxplan.sql
> Table created.
>
> SQL> set autotrace on
> SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is
> enabled
> SP2-0611: Error enabling STATISTICS report
Try :
grant plustrace to dump;
Received on Sun May 14 2006 - 04:17:09 CDT