Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> no able to "set autotrace on" pls chk error

no able to "set autotrace on" pls chk error

From: peter <hhh.database_at_gmail.com>
Date: 14 May 2006 02:10:05 -0700
Message-ID: <1147597805.865378.308070@i40g2000cwc.googlegroups.com>


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 Received on Sun May 14 2006 - 04:10:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US