Skip to Main Content
Forums

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!

Select /*csv*/ output truncated with Java Heap Error

R ToddFeb 6 2014 — edited Feb 7 2014

I am using the latest version (4.0.0.13 build MAIN-13.80) on a Win7 64bit machine, with jdk1.7.0_45.

I am trying to query a table (and spool to file) using csv comment hint (SELECT /*csv*/ * FROM table).

The table has 230 records. Only the first 50 lines appear, then there is an Error in the script output. When I click on the ScriptRunner Task (failed) I see "Java heap space" then more details:

java.lang.OutOfMemoryError: Java heap space

    at java.lang.reflect.Array.newArray(Native Method)

    at java.lang.reflect.Array.newInstance(Array.java:70)

etc

I've tried changing Preferences...Database...Advanced...SQL Array Fetch size from 50 to 200 (I get 200 lines out).

I've tried changing JVM settings in product.conf to increase memory from 880M to 1250M. No change.

Can you suggest anything to try?

Comments

Try it without a blank in the path name.
Shay Shmeltzer-Oracle
Try installing JDeveloper in a directory that doesn't have a space in it's name something like C:\jdev1013. Let us know if it solves your problem.
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 7 2014
Added on Feb 6 2014
#sql-developer, #sqldeveloper
4 comments
2,459 views