If this is the full table, is there a reason you are not trying a backup/restore? I
don't know which backup utilities you are using on either side but this would avoid any
programming or file manipulation. Also, there are DB tols, like DBArtisan, that would
just about do a copy/paste. Check if you have access to one of these tools.
-----Original Message-----
From: Marcotullio, Angelo [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 08, 2001 10:55 AM
To: '[EMAIL PROTECTED]'
Subject: Data Extract
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!
