Home » RDBMS Server » Networking and Gateways » Database gateways vs Transparent gateways (Oracle 11g R2, Oracle 9i R2)
Database gateways vs Transparent gateways [message #502447] Wed, 06 April 2011 06:27
Messages: 183
Registered: March 2008
Location: United Kingdom
Senior Member

I have a confusion regarding database gateways and generic connectivity over different releases and versions of Oracle

Could you please help me confirm my understanding on the followng?

There are 2 ways to connect, replicate, migrate data from Oracle to Non-Oracle databases

1) Database Gateways a2) Database Gateway for ODBC i.e. DG4ODBC

Database Gateways (since 11g) have replaced Trasparent Gateways which existed in 9i

Generic connectivity which existed in 9i is replaced by DG4ODBC since 11g

Both Database Gateways and DG4ODBC support Windows 32/ 64 bit as wel as Linux 32/64 bit since 11g release 2
Of course I assume here that DG4ODBC drivers are available for both 32 as well as 64 bit for non-oracle database

Please suggest

Thanks and Regards,
Previous Topic: Ora-12514
Next Topic: extract tnsnames.ora path using SQLPlus
Goto Forum:

Current Time: Sat Oct 24 16:05:39 CDT 2020