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
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?

Re: Oracle Discoverer Question [message #274934 is a reply to message #273761] Wed, 17 October 2007 14:24 Go to previous message
Messages: 913
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: 1247 error when running jsp on reports server
Next Topic: reports 2 copies with different foooter label
Goto Forum:

Current Time: Sun Aug 20 18:11:25 CDT 2017

Total time taken to generate the page: 0.01286 seconds