Re: SQL*PLUS - SET AUTOTRACE ON problems

On Tue, 05 Aug 2003 18:34:51 GMT, "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:
>
>---------------------------------
>
>SQL> grant plustrace to system;
>
>Grant succeeded.
>
>SQL> @e:\oracle9i\RDBMS/ADMIN/UTLXPLAN.SQL
>
>Table created.
>
>SQL> set autotrace on
>ERROR:
>ORA-24315: illegal attribute type
>
>
>SP2-0619: Error while connecting
>SP2-0611: Error enabling STATISTICS report
>
>--------------------------------------
>
>Can anyone shed some light on what is wrong here?
>
>Thanks,
>
>Randy Nichols
>

Did you run the plustrce.sql script (located in $ORACLE_HOME/sqlplus/adin, IIRC)
The SP2 error messages seem to tell you didn't

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Aug 05 2003 - 14:10:25 CDT