Skip to Main Content

dblink between 9i and 12.2

User_M8BYZMay 7 2018 — edited May 8 2018

Is it possible to create a DBLink between a database on Oracle9i ( and Oracle Database 12c ( - 64bit?

I'm creating a new database using 12c and I want to be able to get my data from the current 9i database to the 12c database.

They are on 2 different servers.

1. Do I need to create an entry in the tnsnames.ora on either server or both?

2. Using oracle client lets me connect to both databases and I can select from tables in both.  Do I need to install it on either server or both?

Thank you

This post has been answered by Hans Steijntjes on May 8 2018
Jump to Answer
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on Jun 5 2018
Added on May 7 2018