I'm a bit confused, I thought I changed the VM memory options in the product.conf file rather than sqldeveloper.conf.
I did try what you suggested and changed AddVMOption -Xmx=512M in sqldeveloper.conf.
SQL developer then would not start. Error:
" Unable to create an instance of the Java Virtual Machine
Located at path: C:\Program Files\Java\jdk1.7.0_45\jre\bin\server\jvm.dll "
More information about test case using /*csv*/
1. The table I am querying is very wide. There are 200 columns.
2. It does seem to work with other tables/queries where there are fewer columns.
I thought I'd managed to successfully get /*csv*/ to work on an equally wide table so hadnt thought that was the problem. I cannot reproduce it working on this other table any more so perhaps it is the table width?
I've forced it to only return 1 or 2 rows as you suggest. The query came back ok; the two records are formatted for csv. They are spooled to a file.
I've then reverted it back to the original query (which previously failed) and it now succesfully returns all 233 records in the table, in csv format, spooled to a file.
No other confiuration settings have changed since the last time i ran it and it failed (i have restarted SQLdeveloper, but i'd also done that many times before and it didnt make any difference those times).
So, sometimes it seems to work, sometimes it doesnt.