OraFAQ Forum: Client Tools » exporting result into excel or text file

Home » Other » Client Tools » exporting result into excel or text file

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

exporting result into excel or text file [message #559289]

Mon, 02 July 2012 01:08

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

Report message to a moderator

Re: exporting result into excel or text file [message #559290 is a reply to message #559289]

Mon, 02 July 2012 01:20

muralikri
Messages: 638
Registered: August 2011
Location: chennai

Senior Member

Just try filter with rownum..and copy the data...

Report message to a moderator

Re: exporting result into excel or text file [message #559292 is a reply to message #559290]

Mon, 02 July 2012 01:27

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

Report message to a moderator

Re: exporting result into excel or text file [message #559293 is a reply to message #559292]

Mon, 02 July 2012 01:30

Littlefoot
Messages: 21782
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).

Report message to a moderator

Re: exporting result into excel or text file [message #559294 is a reply to message #559292]

Mon, 02 July 2012 01:30

muralikri
Messages: 638
Registered: August 2011
Location: chennai

Senior Member

or else use ULT_FILE...

Report message to a moderator

Re: exporting result into excel or text file [message #559295 is a reply to message #559294]

Mon, 02 July 2012 01:30

muralikri
Messages: 638
Registered: August 2011
Location: chennai

Senior Member

sorry UTL_FILE..

Report message to a moderator

Re: exporting result into excel or text file [message #559322 is a reply to message #559289]

Mon, 02 July 2012 10:13

thatjeffsmith
Messages: 81
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.

Report message to a moderator

Previous Topic:	problem related to background session
Next Topic:	Unable to View Table Names

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 26 21:21:16 CDT 2023