RE: Oracle Golden Gate

From: Michael Dinh <mdinh_at_XIFIN.Com>
Date: Thu, 16 Jun 2011 06:10:23 -0700
Message-ID: <D29F9902E534D5478F2E83FD6A44B3063B038A7A5B_at_mail02.mba.xifin.com>

Take a look at Heterogeneous Services.

Done this once before in 9i and it was not bad at all.

http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/ds_concepts001.htm#ADMIN12079

---

From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] On Behalf Of Niall Litchfield [niall.litchfield_at_gmail.com] Sent: Wednesday, June 15, 2011 6:54 AM
To: jreid_at_braintreegroup.com
Cc: ORACLE-L
Subject: Re: Oracle Golden Gate

Golden Gate is a replication technology, not a distributed query technology, you'd want linked servers (in MSSQL) or database gateways (in Oracle) to do joins across different RDBMS instances on different platforms. This is , generally, rather slow.

On Wed, Jun 15, 2011 at 1:16 AM, Joseph Reid <jreid_at_braintreegroup.com<mailto:jreid_at_braintreegroup.com>> wrote: Hi
Has anyone been able to do this with Golden Gate” join live queries from an Oracle database with data in an SQL database. “

Thanks
JR

--

Niall Litchfield
Oracle DBA
http://www.orawin.info
--

http://www.freelists.org/webpage/oracle-l Received on Thu Jun 16 2011 - 08:10:23 CDT