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!

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

Check "Setting the Oracle Environment for PHP on Linux" p 77 and "Commonly Seen Connection and Environment Errors" p 157 of The Underground PHP and Oracle Manual

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

Post Details

Locked on Dec 17 2009
Added on Feb 28 2008
#configuration, #developer, #excel, #export, #memory, #sql, #sql-developer, #sqldeveloper
12 comments
6,222 views