Is it possible to create a DBLink between a database on Oracle9i (18.104.22.168.0) and Oracle Database 12c (22.214.171.124.0) - 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 126.96.36.199 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?