Home » Developer & Programmer » Reports & Discoverer » Oracle Discoverer Question (Exporting results of a query to a text file)
icon8.gif  Oracle Discoverer Question [message #273761] Thu, 11 October 2007 10:22 Go to next message
freddbase
Messages: 1
Registered: October 2007
Junior Member
The query executes quicjkly, but on export writes the data in 24kb chunks, which is very problematic for large files (more than a million records).

Is there any way to speed up the export/write operation?

Fred
Re: Oracle Discoverer Question [message #274934 is a reply to message #273761] Wed, 17 October 2007 14:24 Go to previous message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
Copy the SQL statement, run in it SQL*Plus, use spool?
(Discoverer is not designed for exporting large volumes of data)
Previous Topic: Printing multiple copies for a report with different copy names
Next Topic: CHART OF ACCOUNTS HIERARCHY
Goto Forum:
  


Current Time: Sat Dec 03 09:46:46 CST 2016

Total time taken to generate the page: 0.06843 seconds