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@hotma To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
il.com> cc:
Sent by: Subject: set autotrace error ??
root@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: [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:
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).
