This seems all wrong. I don't see why Oracle would want a group by list - i don't think it would guarantee uniqueness in the subquery.

I think you are missing something in the analysis of the problem here. Can you post the full view definition?

also, is the structure of the tables exactly the same, including constraint definitions, in the 8i and 9i versions?