Hello,
Using Oracle 1.5.5. I am doing a query on some data related to an electronic health record. I am pulling one years worth of data related to certain events in the ehr. The results are about 14 million rows. When I export the data it fetches well at first doing about 1-2K lines per second. Over time it starts to slow way down and eventually the progress bar stops moving and grinds to a halt. Then the oracle GUI starts twitching and acting weird. When I limit the query to a weeks worth of data 25K rows it spits the query out fine. When I start to try to get a month out it dies trying to export. I've tried exporting as text and csv and get the same results. I'm not really sure where to go from here any help would be appreciated.
Thanks,
Steve