explain plan

explain plan

Post by Marc Albau » Fri, 20 Apr 2001 21:39:00



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:


          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