SQL Developer hangs while exporting data to CSV file
HI,
I am using SQL developer 4.1.1.19. I am trying to spool 600,000 record from a table to csv file. Sometimes the spool works perfectly and sometimes it hangs in between. When looking at the memory consumption, I could see that SQL developer consume around 1 GB of memory.
set echo off
column tm new_value file_time noprint;
select to_char(sysdate, 'MMDDYY') tm from dual ;
spool "D:\Warehouse\Public\filename_&file_time..csv"
SELECT /*csv*/ * from Table ;
spool off;
Please let me know how can I resolve the issue ?
Thanks
Ebin