Matthias did you ever get an answer to your problem? I'm seeing the same error, but mine shows more information, "ORA-01795: maximum number of expressions in a list is 1000". The table I'm doing the join on has just over 3,000 entries, I cannot make that smaller than 1,000.
At this point I'm not sure what to do.
When I run a join on the table in ArcMap from the Layer Properties window it works, I just can't run the spatial Join tool. I would like to run the tool from a model.
Any advice?
Thanks
Michelle