Home » SQL & PL/SQL » SQL & PL/SQL » Explain plan help (Oracle,, solaris)
Explain plan help [message #572842] Tue, 18 December 2012 02:21 Go to next message
Messages: 33
Registered: February 2012

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
Re: Explain plan help [message #572843 is a reply to message #572842] Tue, 18 December 2012 02:23 Go to previous messageGo to next message
Messages: 1478
Registered: May 2010
Location: UK
Senior Member
I didnt think dbms_xplan existed in v8.

Try $ORACLE_HOME/rdbms/admin/utlxpls.sql
Re: Explain plan help [message #572846 is a reply to message #572843] Tue, 18 December 2012 02:33 Go to previous message
Michel Cadot
Messages: 65154
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And you are right.

Previous Topic: ORA-03113 end-of-file on communication channel
Next Topic: Join tables on Date with MAX
Goto Forum:

Current Time: Wed Aug 23 02:56:47 CDT 2017

Total time taken to generate the page: 0.05981 seconds