EA2 Failure on Export to CSV 5ooK rows
527366Feb 28 2008 — edited Nov 19 2009I have not been able to export the results of a very large query (greater than 500,000 rows 25 columns) to a csv file in any of the past versions or present version (EA2) of SQL Developer. Exporting any very large query always results in a csv file with a 0 Kb size.
Using the Tables Data CSV export on a very large table also results in a 0 Kb size csv file.
Is SQL Developer designed to only export a limited amount of data? If so what is that limitation? I have exported 100,000 rows with 25 columns without problems.
I have been able to export 700,000 row queries using a competitor's product. I can only export this many rows by first choose an Export to File feature. In this product, I can't first run the very large query and then export it. I first have to directly export the query to a csv file - I don't see the query output in the Results tab like in SQL Developer when using the Export to File feature.