Re: SQL*PLUS - SET AUTOTRACE ON problems

Perhaps that is the problem.

I've never been clear on the difference between "SYSTEM" and "SYS". Can you point me to a good discussion or describe it?

-Randy Nichols

"Lucyna Witkowska" <ypwitkow_at_nospamcyf-kr.edu.pl> wrote in message news:bgqb3e$r1k$1_at_srv.cyf-kr.edu.pl...
> Randy Nichols <randynichols_at_yahoo.com> wrote:
> > As an inexperienced Oracle user, I am struggling with basic oracle
problems.
> > In trying to diagnose the problems, I run into more problems.
>
> > Here I am trying to enable the SQL*PLUS autotrace in hopes of getting
some
> > information on my Advanced Queueing setup problems. But I cannot even
get
> > the autotrace working.
>
> > I logged in as SYSTEM as SYSDBA and created the plustrace role. Then I
get
> > the following:
>
> You should login as SYS when you create the plustrace role.
>
> Greetings,
> LW
>
Received on Wed Aug 06 2003 - 10:14:56 CDT