OraFAQ Forum: SQL & PL/SQL » Explain plan help

Home » SQL & PL/SQL » SQL & PL/SQL » Explain plan help (Oracle, 8.1.7.4.0, solaris)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Explain plan help [message #572842]

Tue, 18 December 2012 02:21

savugar
Messages: 31
Registered: February 2012

Member

Hi,

I am getting below error while generating explain plan. I beleive nothing wrong in the below statement. I am not sure why this error is coming? pls help.

SQL> select plan_table_output from table(dbms_xplan.display('plan_table',null,'serial'));
select plan_table_output from table(dbms_xplan.display('plan_table',null,'serial'))
                                               *
ERROR at line 1:
ORA-00904: invalid column name

Report message to a moderator