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).
