Re: Exporting Oracle Data to DB2
Date: 1995/05/08
Message-ID: <1995May8.063843.4751_at_inet.d48.lilly.com>#1/1
Subject: Exporting Oracle Data to DB2
From: Tryphon Georgallides, tryphon_at_ti.com
Date: 3 May 1995 15:00:59 GMT
In article <3o85rb$ash_at_tilde.csc.ti.com> Tryphon Georgallides,
tryphon_at_ti.com writes:
>Hello gang,
>
>I have a client who came up with the "excellent idea" of exporting
>his ORACLE V6 Data and import it into an MVS DB2 DataBase.
>As you can imaging this means big trouble.
>Has anyone out there done such a thing before ?
>Do I stand any chance of succeeding or will I have to import
>data manually ?
>Ideally is there a tool that can perform such tasks ?
>
>Thanks for reading,
>Tryphon.
You could use ORACLE's Transparent Gateway product to do this. However, I wouldn't recommend it for large amounts of data. The data transfer rate that we see with the product doesn't compare to the manual process.
Depending on how often you plan to do it, and how standardized the process is, it would probably be cheaper just to spool the data out. It is easier to use the transparent gateway, because you use db links and the sqlplus COPY command. I don't think that a single user could justify the expense, though.
Bob Swisshelm | swisshelm_at_Lilly.com | 317 276 5472 Eli Lilly and Company | Lilly Corporate Center | Indianapolis, IN 46285 Received on Mon May 08 1995 - 00:00:00 CEST