Re: Transfering data from DB2 to Oracle

From: Joe Raube <jraube_at_yahoo.com>
Date: Mon, 29 Jul 2002 06:43:25 -0800
Message-ID: <F001.004A48F4.20020729064325@fatcity.com>

I've done db to db transfers using either

1. Perl/DBI - db to db - select from first, insert into second
2. Perl/DBI - select from first, create file for SQL*Loader, load into Oracle using SQL*Loader

I've usually found #2 to be quicker...usually...

-Joe

• "Schauss, Peter" <SCHAUPE_at_mail.northgrum.com> wrote:
  > We have an application which will require us to reload some
  > Oracle tables on a regular basis from a main frame DB2 database.
  > Management does not want to spring for the cost of any connectivity
  > tools. Short of the obvious dump-to-a-text-file/input-with-sqlldr
  > appoach, is there any other way to do this?
  >
  > thanks,
  > Peter Schauss
  

  ---

Do You Yahoo!?
Yahoo! Health - Feel better, live better http://health.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Raube
  INET: jraube_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Mon Jul 29 2002 - 09:43:25 CDT