Home » SQL & PL/SQL » Client Tools » exporting result into excel or text file
exporting result into excel or text file [message #559289] Mon, 02 July 2012 01:08 Go to next message
srikanth_d5
Messages: 39
Registered: June 2012
Location: hyderabad
Member
Hi experts,

i'm working on sql developer my table contains 40 columns and contains around 4 to 5 lakhs records........

when i'm trying to export the results into excel or text file my sql developer is getting hanged...
if the result is less than 2lakh record its copying....

Kindly suggest me.....

Thanks and regards
Re: exporting result into excel or text file [message #559290 is a reply to message #559289] Mon, 02 July 2012 01:20 Go to previous messageGo to next message
muralikri
Messages: 638
Registered: August 2011
Location: chennai
Senior Member

Just try filter with rownum..and copy the data...
Re: exporting result into excel or text file [message #559292 is a reply to message #559290] Mon, 02 July 2012 01:27 Go to previous messageGo to next message
srikanth_d5
Messages: 39
Registered: June 2012
Location: hyderabad
Member
Thanks...i know i can use rownum() i got same issue with other table it contains around 50 lakhs records and i'm afraid to execute 25 times....some of my colleagues export their result in Linux using sql plus.....
is there any credentials that sql developer cannot export more than 2lakh records.....

thanks and regards
Re: exporting result into excel or text file [message #559293 is a reply to message #559292] Mon, 02 July 2012 01:30 Go to previous messageGo to next message
Littlefoot
Messages: 19326
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Maybe it is Excel to be blamed for that. Which Excel version do you use? Older versions are capable of storing only 64K of records (newer 1M, unless I'm wrong).
Re: exporting result into excel or text file [message #559294 is a reply to message #559292] Mon, 02 July 2012 01:30 Go to previous messageGo to next message
muralikri
Messages: 638
Registered: August 2011
Location: chennai
Senior Member

or else use ULT_FILE...
Re: exporting result into excel or text file [message #559295 is a reply to message #559294] Mon, 02 July 2012 01:30 Go to previous messageGo to next message
muralikri
Messages: 638
Registered: August 2011
Location: chennai
Senior Member

sorry UTL_FILE..
Re: exporting result into excel or text file [message #559322 is a reply to message #559289] Mon, 02 July 2012 10:13 Go to previous message
thatjeffsmith
Messages: 36
Registered: July 2009
Location: Raleigh, NC
Member

You're JVM is probably running out of memory.

Try exporting to CSV instead, does that work?

You can add memory to the jvm by adding this line to your ide.conf file
AddVMOption -Xmx1024M

Shutdown sql dev, then make that change, then start sql dev and try the export to XLS

We're looking at making an update in a future release that won't require as many resources for large Excel imports and exports.
Previous Topic: problem related to background session
Next Topic: Unable to View Table Names
Goto Forum:
  


Current Time: Tue Jul 29 14:05:07 CDT 2014

Total time taken to generate the page: 0.09519 seconds