Re: Write millions of records of data to a flat file

On 22 Jul 2005 13:27:14 -0700, "nickli" <ningli2000_at_hotmail.com> wrote:

>Hi,
>
> I have a table which contains over 30 million rows of data (over 50
>columns). I need to write all the data to a flat file with specified
>delimiter, header and output file name. Which tool is the fastest for
>this task? I can think of tools such as PL/SQL UTL_FILE package, Java
>stored procedure, Perl DBI, among others.
>
> Thanks in advance.
>
> Nick Li

Anything using array fetches, so BULK COLLECT in PL/SQL combined with UTL_FILE should do fine.
Anything else would be probably slower, because it is running outside the database and has extra network traffic associated.

--
Sybrand Bakker, Senior Oracle DBA