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

  • From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 7 Jul 2006 07:28:43 -0400

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

Other related posts:

  • » DBMS_XPLAN error....anyone seen this one before?
  1. Home
  2. oracle-l
  3. Archive
  4. 07-2006