RE: Oracle Golden Gate

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

Take a look at Heterogeneous Services.

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

From: [] On Behalf Of Niall Litchfield [] Sent: Wednesday, June 15, 2011 6:54 AM
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 <<>> 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. “



Niall Litchfield
Oracle DBA
-- Received on Thu Jun 16 2011 - 08:10:23 CDT

Original text of this message