Re: explain plan

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 19 Apr 2001 14:24:17 +0100
Message-ID: <987686442.1078.0.nnrp-07.9e984b29@news.demon.co.uk>

This may be the result of upgrades.
PLAN_TABLE has changed over time,
so the version that exists in your database may not be the version that is fully up to date for your database.

Look at $ORACLE_HOME/rdbms/admin/utlxplan.sql for the latest creation script and compare.

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases
Publishers:  Addison-Wesley

Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



Marc Albaum wrote in message
<3adedc19$0$20636$4dbef881_at_businessnews.de.uu.net>...


>Hi everyone!

>

>I've tried to analyze a select statment with an explain plan. Worked fine.

>But when I try to display the output, as mentioned in the Oracle Tech Net,

>with calling $ORACLE_HOME/rdbms/admin/utlxpls.sql it returns the following

>error:

>

>

>SQL> @?/rdbms/admin/utlxpls

>          decode(partition_stop,null,' ',partition_stop)))))||' ', 7, '

>')||'|'

>as "Explain plan"

>                                         *

>ERROR at line 33:

>ORA-00904: invalid column name

>

>The table exists. I work with Oracle 8.1.6 and SuSE Linux 7.0.

>Did anyone already encounter this problem?

>

>Thanks

>Marc

>

>

Received on Thu Apr 19 2001 - 08:24:17 CDT