ORA-03113 end-of-file on communcation channel

Hello.

I am doing what I thought was a simple join between an existing table and a sub-select query. That sub-select contains approximately 3.200 clauses as follows (select x, y, z from dual union all…).

I hums a bit and dies with that message. I gather that I have exceeded some limit here and think that it is an Oracle issue since I have this problem whether I use F9, F5, SQL+ or QSR.

Can someone point me to where this is explained and/or discussed so I can better communicate the issue and possible work-arounds?

Thank you.