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!

Export Data (CSV) results in empty 0 Byte files

566589Mar 12 2007 — edited Nov 7 2007

Oracle SQL Developer 1.1.2.25 build main-25.79
Oracle 7.3.2.0.0

Exporting large amount of data by right clicking on the view, then select Export Data > CSV, all columns checked, no WHERE clause, save to local file ends up with 0 Byte export file with no data. SQL developer takes up a lot of memory (0.5GB) in the machine, so definitely data has been downloaded to memory, but not written out to a file. The view contains about 0.4 GB of data with about a million records.

Smaller tables (<1000 records) are exported correctly.

Is this a confirmed bug? Any confirmed workarounds? Attempting the Data tab, then export workaround now, but only exported 40KB after running about an hour.

Thanks in advance,
Yoon

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 5 2007

Added on Mar 12 2007

#sql-developer

5 comments

4,685 views