RE: dump large amounts of data to a flat file
Date: Mon, 27 Oct 2008 12:48:32 -0500
Message-ID: <785A4E1EF4D9E745BAC909B7941BEC009EFC69@usplm201.amer.corp.eds.com>
You can always user utl_file package ^_^
Guillermo Alan Bort
DBA / DBA Main Team
EDS, an HP company
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Niall Litchfield
Sent: Monday, October 27, 2008 3:23 PM
To: ballester.david_at_gmail.com
Cc: oracledbaquestions_at_gmail.com; oracle-l_at_freelists.org
Subject: Re: dump large amounts of data to a flat file
http://asktom.oracle.com/tkyte/flat/index.html
that'll keep you going for a while.
On Mon, Oct 27, 2008 at 5:18 PM, David Ballester <ballester.david_at_gmail.com> wrote:
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.
-- Niall Litchfield Oracle DBA http://www.orawin.info -- http://www.freelists.org/webpage/oracle-lReceived on Mon Oct 27 2008 - 12:48:32 CDT