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!

sql developer 2.1.0.62.61: export to excel fails

724704Sep 28 2009 — edited Sep 29 2009
I have just installed the newest version of SQL Seveloper EA (2.1.0.62.61). The export to an Excel file will only work if less than 10.000 records are selected. From the 10.000th Record on the export process extremly slows down and the Excel file quickly becomes larger than 1 gigabyte. (currently 17,000 records and 25 gigabytes of file size!!). If the disk is full, the export will collapse at some point (German Error message 'There is not enough disk space available' below) The Export as CSV file works fine!

java.io.IOException: Es steht nicht genug Speicherplatz auf dem Datenträger zur Verfügung
at java.io.FileOutputStream.writeBytes(Native Method)
at java.io.FileOutputStream.write(FileOutputStream.java:260)
at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)
at java.io.BufferedOutputStream.write(BufferedOutputStream.java:109)
at java.io.FilterOutputStream.write(FilterOutputStream.java:80)
at org.apache.poi.poifs.storage.BigBlock.doWriteData(BigBlock.java:54)
at org.apache.poi.poifs.storage.DocumentBlock.writeData(DocumentBlock.java:219)
at org.apache.poi.poifs.storage.BigBlock.writeBlocks(BigBlock.java:85)
at org.apache.poi.poifs.filesystem.POIFSDocument$BigBlockStore.writeBlocks(POIFSDocument.java:602)
at org.apache.poi.poifs.filesystem.POIFSDocument.writeBlocks(POIFSDocument.java:274)
at org.apache.poi.poifs.filesystem.POIFSFileSystem.writeFilesystem(POIFSFileSystem.java:262)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.write(HSSFWorkbook.java:742)
at oracle.dbtools.raptor.format.ExcelFormatter.startRow(ExcelFormatter.java:93)
at oracle.dbtools.raptor.format.ui.TableFormatterWrapper.print(TableFormatterWrapper.java:206)
at oracle.dbtools.raptor.format.ResultsFormatter.print(ResultsFormatter.java:195)
at oracle.dbtools.raptor.format.ResultsFormatter.doPrint(ResultsFormatter.java:396)
at oracle.dbtools.raptor.dialogs.actions.TableExportAction$5.doWork(TableExportAction.java:582)
at oracle.dbtools.raptor.dialogs.actions.TableExportAction$5.doWork(TableExportAction.java:579)
at oracle.dbtools.raptor.backgroundTask.RaptorTask.call(RaptorTask.java:193)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask.run(RaptorTaskManager.java:489)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 27 2009
Added on Sep 28 2009
2 comments
1,431 views