Re: What is fastest way to extract large table to flat text file

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Tue, 17 Jul 2001 22:03:47 -0400
Message-ID: <5jr9ltoit9dpvu7uhf5setcgoteofdt6eu@4ax.com>

On 17 Jul 2001 20:15:05 -0500, sdfes_at_dsf.com (sdfsd) wrote:

>1 - use sqlplus do a spool. Concerns are: network traffic sending it to
>Sqlplus, cost of having it processed for display even if we dont have it
>displayed, concerns about limits of how big a file it can handle.

Use SET TERMOUT OFF to eliminate the display processing, and use SQL*Plus on the server to avoid the network traffic.

Jonathan Gennick
mailto:jonathan_at_gennick.com
http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org Received on Tue Jul 17 2001 - 21:03:47 CDT