Skip to Main Content

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!

EA2 Failure on Export to CSV 5ooK rows

527366Feb 28 2008 — edited Nov 19 2009
I 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.

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 17 2009
Added on Feb 28 2008
12 comments
6,207 views