RE: Oracle + Sybase

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.
>
> Thanks,
>
> Mike
>
>
> **************************************************************
> **************
> This e-mail contains privileged attorney-client
> communications and/or confidential information, and is only
> for the use by the intended recipient. Receipt by an
> unintended recipient does not constitute a waiver of any
> applicable privilege.
>
> Reading, disclosure, discussion, dissemination, distribution
> or copying of this information by anyone other than the
> intended recipient or his or her employees or agents is
> strictly prohibited. If you have received this communication
> in error, please immediately notify us and delete the
> original material from your computer.
>
> Sempra Energy Trading Corp. (SET) is not the same company as
> SDG&E or SoCalGas, the utilities owned by SET's parent
> company. SET is not regulated by the California Public
> Utilities Commission and you do not have to buy SET's
> products and services to continue to receive quality
> regulated service from the utilities.
> **************************************************************
> **************
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Xin \"Michael\" Wu
> INET: xwu_at_sempratrading.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Tue Jan 02 2001 - 11:22:09 CST