RE: Oracle Golden Gate

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@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] On Behalf 
Of Niall Litchfield [niall.litchfield@xxxxxxxxx]
Sent: Wednesday, June 15, 2011 6:54 AM
To: jreid@xxxxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxxx<mailto:jreid@xxxxxxxxxxxxxxxxxx>> 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


Other related posts: