First, run $ORACLE_HOME/sqlplus/admin/plustrce.sql as internal to create the
PLUSTRACE role. Then grant PLUSTRACE to the users (or to public if for
everyone) who want to use autotrace.
You also need to also make sure to run $ORACLE_HOME/rdbms/admin/utlxplan.sql
to set up the plan table in each schema that will be using autotrace, as
said by Ron previously.
Defry
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, June 26, 2001 4:26 PM
Have you created the Explain Plan table correctly? The table creation script
is located in $ORACLE_HOME/rdbmsxxx/admin/utlxplan.sql
ROR m���m
>>> [EMAIL PROTECTED] 06/26/01 10:30AM >>>
We have ORACLE 8.1.6.1 database and I login as DBA and tried to turn on
autotrace. I got
following error messages:
SQL> set autot on
ERROR:
ORA-00904: invalid column name
SP2-0611: Error enabling EXPLAIN report
Any ideal?
Thanks
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: ef 8454
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mustafa
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
