Grid export limits

Toad for Oracle
1

I need to export over 13M rows of data from a select statement into a .txt file. I would like to generate the single .txt file export. My physical memory won’t take it. I usually create the SQL query and export from the grid. What is the best way to deal with it other than trying to limit the size of the export and doing multiple files? The final file will be around 500Mb size.

Thank you.

2

Try F9 to run the top 500 rows and in the data grid section click on the icon export dataset and you should be able to output the full result from the select statement. I unchecked the display all results in grid in the export dataset window. Hope it helps.