Re: set autotrace error ??

From: <DBarbour_at_austin.isd.tenet.edu>
Date: Tue, 26 Jun 2001 10:29:21 -0700
Message-ID: <F001.00338955.20010626102708@fatcity.com>

My ideal is a vast ranch - as far away from technology as I can get. In the meantime:

The "error enabling EXPLAIN report" is your best clue. You've enabled autotrace with it's default options, which include executing an EXPLAIN PLAN. You probably have not created the PLAN table. Try running utlxplan.sql then see if your autotrace works.

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002

                                                                                       
                       
                    "ef 8454"                                                          
                       
                    <ef8454_at_hotma        To:     Multiple recipients of list ORACLE-L 
<ORACLE-L_at_fatcity.com>  
                    il.com>              cc:                                           
                       
                    Sent by:             Subject:     set autotrace error ??           
                       
                    root_at_fatcity.                                                      
                       
                    com                                                                
                       
                                                                                       
                       
                                                                                       
                       
                    06/26/2001                                                         
                       
                    09:30 AM                                                           
                       
                    Please                                                             
                       
                    respond to                                                         
                       
                    ORACLE-L

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: 
  INET: DBarbour_at_austin.isd.tenet.edu

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 - 12:29:21 CDT