Toad World® Forums

Out of memory error

After running a query that returned over 500K rows and sending it to LocalDB as part of Automation, I receive an Out of Memory Error. Please see the image. Any thoughts?

tdp out of memory.png

Do you have the same problem if you store this result set in Local Storage not in the context of Automation?

Automation script itself might be of some help here as well. Can you also post it?

Thanks,

Igor.

From: TDP_OWL [mailto:bounce-TDP_OWL@toadworld.com]

Sent: Wednesday, June 19, 2013 6:06 AM

To: toaddatapointbeta@toadworld.com

Subject: [Toad Data Point - Beta Discussion Forum] Out of memory error

After running a query that returned over 500K rows and sending it to LocalDB as part of Automation, I receive an Out of Memory Error. Please see the image. Any thoughts?

I had the same problem when going from query> results> send to LocalDB.