Re: Oracle + Sybase

I've been told that Oracle is in the process of rewriting the Transparent Gateways for 8i and I have been unable to find any good source of information on them. Metalink has conflicting and outright incorrect information, especially in the Forum areas. So be warned. We need an interface between Oracle and Informix. Because of the inability to get accurate information including future direction, we are planning to not use this software and are currently investigating products from Merant (which bought Intersolve). They have stated that 2-phase commit is supported, but we have not verified that yet.

Marc Perkowitz
MTP Systems Consulting

In a message dated 1/2/2001 11:32:54 AM Central Standard Time, Shawn.Ferris_at_twtelecom.com writes:

<< Look into sybase replication. It will do replication to/from many different  RDBMS.    Alternatively look at oracle transparent gateways. I believe you could do  the same and from what I understand this is the only product (at least  4-5years ago) that supported 2 phased commits to a third party db.  

 HTH
 Shawn M Ferris
 Oracle DBA - Time Warner Telecom  

> -----Original Message-----
> From: Xin "Michael" Wu [mailto:xwu_at_sempratrading.com]
> Sent: Tuesday, January 02, 2001 8:31 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Oracle + Sybase
>
>
> Hello,All,
>
> I have a question related to syncing an Oralce table and a
> Sybase table. If
> I want to insert a record into one of my Oracle tables, the
> corresponding
> record should be inserted into my Sybase table. I know I can
> setup a trigger
> to handle that. But how do I let Oracle talk with Sybase,and
> vise versa?
>
> Your suggestion is highly appreciated.
Received on Tue Jan 02 2001 - 15:52:29 CST