data would not fit in current prefetch buffe

[nigel]

Hi,

I encountered the same error. In my case, the error occured on a lookup table. Staging the data to a hash table and then reading from the hash table solved my problem.
I've raised this with Oracle and am still awaiting a solution.
The DBAs tried everything to resolve this including dropping and recreating the table and setting traces on the DB.

My solutuion is a work-around, but it does solve the problem

Hope this helps

Nigel

Nigel