RE: dump large amounts of data to a flat file
- From: "Newman, Christopher" <cjnewman@xxxxxxxxxxxxx>
- To: <ballester.david@xxxxxxxxx>, <oracledbaquestions@xxxxxxxxx>
- Date: Mon, 27 Oct 2008 12:20:42 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of David Ballester
Sent: Monday, October 27, 2008 12:19 PM
To: oracledbaquestions@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: dump large amounts of data to a flat file
2008/10/27 Dba DBA <oracledbaquestions@xxxxxxxxx>
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
