Re: no able to "set autotrace on" pls chk error

peter wrote:
> 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
>
> I don't know how to solve this error pls help

A complete demo can be found in Morgan's Library at www.psoug.org under Autotrace.

The PLUSTRACE role is granted using $ORACLE_HOME/rdbms/admin/plustrce.sql.

PS: Very bad form to grant CONNECT and RESOURCE. Learn to use specific system and object privileges and/or create your own roles.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org