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
data would not fit in current prefetch buffe
Moderators: chulett, rschirm, roy