Skip to Main Content

Oracle Database Discussions

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!

Exporting 100,000+ rows to excel

624226Jun 20 2008 — edited Jun 20 2008
We have a SQL SELECT statement that we wish to export to excel. We are using TOAD but to be blunt is rubbish at this. It first reads everything into memory which so far is using almost 1GB and has taken over 24 hours. The computer is using most of its time allocating memory! Does anyone know of any tools which take a SELECT statement and create a excel file without loading all the data into memory?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 18 2008
Added on Jun 20 2008
11 comments
2,233 views