Re: dump large amounts of data to a flat file
From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Mon, 27 Oct 2008 17:22:47 +0000
Message-ID: <7765c8970810271022y42049ccegb74f272ab4726b40@mail.gmail.com>
Date: Mon, 27 Oct 2008 17:22:47 +0000
Message-ID: <7765c8970810271022y42049ccegb74f272ab4726b40@mail.gmail.com>
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:22:47 CDT