RE: dump large amounts of data to a flat file

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).

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of David Ballester Sent: Monday, October 27, 2008 12:19 PM
To: oracledbaquestions_at_gmail.com
Cc: oracle-l_at_freelists.org
Subject: Re: dump large amounts of data to a flat file

2008/10/27 Dba DBA <oracledbaquestions_at_gmail.com> 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

Regards

D.

--
http://www.freelists.org/webpage/oracle-l