Q
Problem solve Get help with specific problems with your technologies, process and projects.

Connecting to Oracle9i table from DB2

From a DB2 database (Table X), how to connect to a Oracle9i database (Table Y) and select values from Table X into Table Y using DBlink?

We have a requirement like this: From a DB2 database (Table X), how to connect to a Oracle9i database (Table Y) and select values from Table X into Table Y using DBlink?
What you need is the Oracle-DB2 transparent gateways product. This article from Oracle provides more details on this.

Dig Deeper on Oracle data and application integration

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close