You can't restore across platforms. The Oracle datafile structures are
different.
Doing a DB -> DB copy (using an Oracle "DB_LINK") across the network is
going to be real slow. Also, if it fails 95% thru, it will be impossible to
load the remaining 5%. I'll have to start from the beginning.
-----Original Message-----
From: De Simone, Andrew (CAP, FGI)
[mailto:[EMAIL PROTECTED]]
Sent: Friday, June 08, 2001 3:44 PM
To: 'Marcotullio, Angelo '; '[EMAIL PROTECTED]'
Subject: RE: Data Extract
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!
