Re: Autotrace

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: 2000/07/10
Message-ID: <3969DD73.7C76@yahoo.com>#1/1

Walter T Rejuney wrote:
>
> I just tried to set autotrace on in an 8i Release 2 datatabe and here is
> what I got when I am logged into a user account.
>
> SQL> set autotrace on;
> SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is
> enabled
> SP2-0611: Error enabling STATISTICS report
>
> What do I have do to make this work. If I log in as SYSTEM it works
> fine. How to I enable the PLUSTRACE role?

In $ORACLE_HOME/sqlplus/admin there is a pupbld.sql which creates the role - grant it to public and you're away.

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse

Received on Mon Jul 10 2000 - 00:00:00 CDT