RE: dump large amounts of data to a flat file

From: Newman, Christopher <>
Date: Mon, 27 Oct 2008 12:20:42 -0500
Message-ID: <>

Datapump with SQLFILE=, (Use the CONTENT as well if you just want the data only) then use sed/awk to manipulate the output to your liking (vi won't work if the file is too large).

[] On Behalf Of David Ballester Sent: Monday, October 27, 2008 12:19 PM
Subject: Re: dump large amounts of data to a flat file

2008/10/27 Dba DBA <> not talking about an export. I need a comma delimitted file. large amounts of data. is there anything better than spool? sql developer does not work on large data sets.

spool the select output or use the text_io package



Received on Mon Oct 27 2008 - 12:20:42 CDT

Original text of this message