Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle l »

DBMS_XPLAN error....anyone seen this one before?

Bobak, Mark

2006-07-07


DBMS_XPLAN error....anyone seen this one before?

SQL> select * from table(dbms_xplan.display);

PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------------------------------------------------

An uncaught error happened in fetching the records : ORA-30929: ORDER SIBLINGS BY clause not allowed here
ORA-30929: ORDER SIBLINGS BY clause not allowed here

2 rows selected.



Fairly complex query, Oracle 9.2.0.5 on Sparc Solaris 8.

--
Mark J. Bobak
Senior Oracle Architect
ProQuest Information & Learning

Ours is the age that is proud of machines that can think and suspicious of men who try to.  --H. Mumford Jones, 1892-1980


©2008 dba.5341.com - Jax Systems, LLC, U.S.A.