meta link says
This error is caused by bug 1621216 which is fixed in Oracle9i.
This is an optimizer bug so you can workaround it by issuing an alter session set optimizer_mode=rule before the query.


But i got in 9i :-) may be u should wait for 10i (Packed with more newer bugs)