Return
-
Title
Receiving an 'Out of Memory' error exporting dataset to an Excel / CSV file. -
Description
I get an 'Out of Memory' error when I run a query, which generates over a half million rows and export it to an Excel / CSV file.
-
Resolution
WORKAROUND 1:
1. Break up the result sets and write the query to return smaller chunks of results sets. Afterwards, stitch back together the data result sets outside of Toad for Data Analysts.
WORKAROUND2:
1. Launch TDA, connect to DB, go to menu Tools | Export | Export Wizard | Export Category: 'Query'
2. Enter the query directly into the Export Wizard, and then export as CSV.STATUS:
Waiting for fix in a future version of Toad for Data Analysts. -
Defect ID
ST83010