oracle to db2 export

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

t3chn0n3rd - 17 Jan 2008 22:05 GMT

Does anyone know how to export data from an Oracle database to a DB2
database?

Reply to this Message

m - 18 Jan 2008 00:25 GMT

> Does anyone know how to export data from an Oracle database to a DB2
> database?

Export comma delimited ascii files from Oracle - import into DB2

Reply to this Message

Michael Rudolph - 18 Jan 2008 13:10 GMT

> Does anyone know how to export data from an Oracle database to a DB2
> database?

Hi,

try the Redbook named Oracle to DB2 Conversion Guide for Linux, UNIX,
and Windows

http://www.redbooks.ibm.com

Michael

Reply to this Message

Bob Jones - 20 Jan 2008 19:09 GMT

> Does anyone know how to export data from an Oracle database to a DB2
> database?

You can't. Oracle export is proprietary. There are 2 options I can think of.

1. Create flat files from Oracle tables and then import into DB2.
2. Create database link between Oracle and DB2 with OHS.

Reply to this Message