explain plan

From: Marc Albaum <marc_at_strictly-europe.com>
Date: Thu, 19 Apr 2001 14:39:00 +0200
Message-ID: <3adedc19$0$20636$4dbef881@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 - 07:39:00 CDT