SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

xlsx export does not finish - extremely slow Excel export

emssFeb 11 2013 — edited Mar 19 2013

Installed 64bit SQLDeveloper on Win 7 64 bit machine with 4 meg ram.

When I export a large file/qry to Excel, the job basically will not end. The progress bar reports progress iandrecord count increments...eventually freezing the SLQDevelper application. This was one reason why I procured the 64 bit machine - the same problem was being experienced on a 32 bit Win xp system.

I use another tool, PLSQL Developer on the 32 bit as a work-around, and larger files are exported cleanly....but I am hoping to avoid having to use different Developer tools/applications - I prefer SQLDeveloper.

Any thoughts or help on how to get SQLDevelper to perform large (10M) file exports?

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 16 2013

Added on Feb 11 2013

#sql-developer

4 comments

5,404 views