RE: Problem with Autotrace ?

SQL-Plus is a little like the old interactive fiction games (text-based games, like 'Adventure' or 'Zork'). You only need to type enough of some words so that they are unambiguous. See the SQL-Plus User's Guide, "command reference" (chapter 8 for 8.1.7, chapter 13 for 9.2.0) for details.

I'm afraid I don't have anything add to the original question, I was going to suggest the obvious "grant PLUSTRACE" but I reviewed the thread and saw that was already dealt with.

-Chris

> -----Original Message-----
> From: bulbultyagi_at_now-india.net.in
> [mailto:bulbultyagi_at_now-india.net.in]
> Sent: Monday, July 28, 2003 5:14 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Problem with Autotrace ?
>
>
> I don't know much about Oracle,
> Is there a spelling mistake in the command you gave ?
> SQL> set autot trace
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Monday, July 28, 2003 09:19
>
>
> > Guys,
> >
> > when i try the same from a different machine,i get the error below.
> > { this client machine has 9.2.0.2/Win2K server - with SP3 }
> >
> > SQL>connect cti/cti_at_mf;
> > SQL>set autot trace
> > SP2-0618: Cannot find the Session Identifier. Check
> PLUSTRACE role is
> enabled
> > SP2-0611: Error enabling STATISTICS report
> >
> > .seems to be unusual.isn't it ?
> > had anyone faced the same problem ?
> > can someone help me out.
> >
> > Regards,
> > Jp.
> >
>

LEGAL NOTICE:
Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this e-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Sarnowski, Chris
  INET: csarnows_at_CuraGen.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).