Issues with downlaoding if data >1M lines

I can run my qry but toad is giving an error and then crashing if the # of lines exceeds about a a million. Any setting i can change to help?

What database are you trying to access when you have this problem? And what error do you get while doing it?