SQL*Plus (MOSC)

MOSC Banner

SQL Developer hangs while exporting data to CSV file

edited Mar 23, 2016 6:43PM in SQL*Plus (MOSC) 3 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center