Home » SQL & PL/SQL » SQL & PL/SQL » Explain plan help (Oracle, 8.1.7.4.0, solaris)
Explain plan help [message #572842] Tue, 18 December 2012 02:21 Go to next message
savugar
Messages: 33
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
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
Roachcoach
Messages: 1180
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: 58619
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And you are right.

Regards
Michel
Previous Topic: ORA-06502: PL/SQL: numeric or value error
Next Topic: SQL query to retrieve records in frequency of Days
Goto Forum:
  


Current Time: Wed Jul 30 12:30:46 CDT 2014

Total time taken to generate the page: 0.09085 seconds