My Oracle Support Banner

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

Last updated on SEPTEMBER 27, 2019

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.