Re: SQL*PLUS - SET AUTOTRACE ON problems

From: Nuno Souto <wizofoz2k_at_yahoo.com.au>
Date: 5 Aug 2003 19:35:51 -0700
Message-ID: <73e20c6c.0308051835.74bd124b@posting.google.com>

"Randy Nichols" <randynichols_at_yahoo.com> wrote in message news:<xFWXa.34835$Mc.2764615_at_newsread1.prod.itd.earthlink.net>...
> It seems to be the
>
> SET AUTOTRACE ON STATISTICS
>
> that has a problem, giving error:
>
> SQL> set autotrace on statistics
> ERROR:
> ORA-24315: illegal attribute type
>
>
> SP2-0619: Error while connecting
> SP2-0611: Error enabling STATISTICS report
>

wild guess, but I'd say your PLAN_TABLE
is of a different version than what you running now. In $ORACLE_HOME/rdbms/admin (%ORACLE_HOME%\RDBMS\ADMIN if you wash windows), there is a file called UTLXPLAN.sql Run that script logged on as that user and see if it fixes the prob.

Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam Received on Tue Aug 05 2003 - 21:35:51 CDT