Re: set autotrace error ??

From: Mustafa <mdefry_at_hotmail.com>
Date: Tue, 26 Jun 2001 13:44:59 -0700
Message-ID: <F001.00339018.20010626134708@fatcity.com>

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" <ORACLE-L_at_fatcity.com> 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
>>> ef8454_at_hotmail.com 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: ef8454_at_hotmail.com

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: ListGuru_at_fatcity.com (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: RROGERS_at_galottery.org

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: ListGuru_at_fatcity.com (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: mdefry_at_hotmail.com

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: ListGuru_at_fatcity.com (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).

Received on Tue Jun 26 2001 - 15:44:59 CDT