RE: Transfering data from DB2 to Oracle

2002-07-29 Thread Kevin Lange 

If I were you I would talk to that management.

We had a Mainframe DB2 database that needed to have shadow tables created on
Oracle.  What we ended up doing was to get Oracles Gateway for RDB which
allowed us to create queries on Oracle that accessed data on the mainframe
DB2.

We even went one step further and bought their Replication Services Package
(not sure they offer it any more).  This package , in conjunction with IBM's
data propagator, allowed us to create scheduled update jobs that used the
logs created on DB2 to update the Oracle tables.

Instead of getting Rep Services and Data Propogator, you could build your
own queries that pull data to the Oracle tables thru the gateway.   (But you
will still need a way to tell that the data has changed on DB2).

My advice talk to management.   Talk them into at least getting the
gateway.

-Original Message-
Sent: Monday, July 29, 2002 9:08 AM
To: Multiple recipients of list ORACLE-L


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
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Schauss, Peter
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Lange
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re: Transfering data from DB2 to Oracle

2002-07-29 Thread Joe Raube 

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" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).