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 [188.8.131.52.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 184.108.40.206.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 220.127.116.11.0.
I would like to hear from anybody out there with a possible resolution.