Data Extract

[Marcotullio, Angelo]

Hi all,

I need to extract about 500,000,000 rows from a table to a text file for
loading into another database.

Source: NT, Oracle 817
Destination: HP-UX 11, Oracle 817

I plan on using SQL*Loader to load the data, so the extract will need to be
consistently formatted (fixed columns, csv, etc.).

1) Does anything already exist for this type of task?

2) If not, I would appreciate any hints for optimizing my Perl code.

Thank you!