I have been running into this error when I create a View based on embedded view and the Schema User has complete permissions on all the objects in question. The environment is Oracle 9i [22.214.171.124.0]. The one thing that distinguishes this view from any other view is that there are underlying UNION ALL defined. I have a feeling this is a bug that probably got corrected in 126.96.36.199.0.
Also, I have been running into a NO MORE DATA TO READ FROM SOCKET error in few of my ETL scripts. A bug in 188.8.131.52.0.
I would like to hear from anybody out there with a possible resolution.