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

Report message to a moderator

Re: Oracle Discoverer Question [message #274934 is a reply to message #273761] Wed, 17 October 2007 14:24 Go to previous message
skooman
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)

Report message to a moderator

Previous Topic: Printing multiple copies for a report with different copy names
Next Topic: CHART OF ACCOUNTS HIERARCHY
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 02 08:05:27 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.