How to Use a Database Link and a Synonym to Bridge Version Incompatibilities Between RDBMS and Gateways (Doc ID 1294295.1)

Last updated on APRIL 08, 2013

Applies to:

Oracle Database Gateway for Sybase - Version 9.2.0.4 to 11.2.0.2 [Release 9.2 to 11.2]
Oracle Database Gateway for Teradata - Version 9.2.0.4 to 11.2.0.2 [Release 9.2 to 11.2]
Oracle Database Gateway for VSAM - Version 11.1.0.6 to 11.2.0.2 [Release 11.1 to 11.2]
Oracle Database Gateway for WebSphere MQ - Version 9.2.0.4 to 11.2.0.2 [Release 9.2 to 11.2]
Oracle Database Gateway for APPC - Version 9.2.0.4 to 11.2.0.2 [Release 9.2 to 11.2]
Information in this document applies to any platform.
Checked for relevance on 08-April-2013

Goal

  The goal is to select data from a version of RDBMS that is not compatible with the gateway version by using a database link to first access a higher version of RDBMS that is compatible with the gateway version, and that RDBMS database will use a synonym to access the gateway which will access the third party database.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms