Home » Server Options » Replication » oracle replication to DB2 UDB
oracle replication to DB2 UDB [message #75576] Thu, 18 November 2004 01:11 Go to next message
Messages: 128
Registered: November 1998
Senior Member

I try to replicate a table on an Oracle-Database to a DB2-Database.

When I have a working connection to the DB2-Server, how can I replicate my Oracle Table to DB2?

Is there any feature in Oracle (Version 9.2 / on AIX) to do it?

Re: oracle replication to DB2 UDB [message #75581 is a reply to message #75576] Fri, 26 November 2004 01:12 Go to previous message
Frank Naude
Messages: 4570
Registered: April 1998
Senior Member

You can use Oracle Streams with the Oracle Transparent Gateway for DB/2 to replicate data to and from Oracle.

Oracle Streams (part of Oracle 9i) is documented in the Oracle Streams Guide:
See chapters 9 (Streams Heterogeneous Information Sharing) and 22 (Single Source Heterogeneous Replication Example).

Oracle Transparent Gateway for DB/2 is a product that needs to be procured and installed separately.

Best regards.

Previous Topic: Oracle High availabilty between different OS
Next Topic: Replication of LONG in Oracle 9i?
Goto Forum:

Current Time: Mon Dec 06 21:13:53 CST 2021