Re: Exporting Oracle Data to DB2

In article <3o85rb$ash_at_tilde.csc.ti.com> tryphon_at_ti.com (Tryphon Georgallides) writes:

been there, done that. first, you need to decide the frequency of the migration of data. if it needs to be online, then you have a lot of fun ahead. if it can be batch, it is a fairly simple process of extracting the oracle data into a flat file (not export format!), doing any necessary data conversions in the process. one of the most common conversions is for time/date stamps.     

once you have the flat file formatted correctly, you can use whatever import tool you have available for db2.

good luck.

>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.
Received on Sat May 13 1995 - 00:00:00 CEST