This content has been marked as final. Show 4 replies
Your query is executing again b/c you haven't fetched all the rows to the grid(s). If you want to prevent the pain of the 2nd query execution for the export, then scroll to the bottom of the data grid before you do the Export. This will consume more memory, but it will save you the effort of running the query again.
You could also try using SPOOL and the /*csv*/ sql developer hint.
select /*csv*/ * from ...
Execute via F5
The main limitation here will be the number of lines returned by your query as we default the max rows to print in a script to 5,000. That's a preference you can change though.
Edited by: JeffS on Aug 13, 2012 10:10 AM