Is it possible to create a DBLink between a database on Oracle9i (9.2.0.6.0) and Oracle Database 12c (12.2.0.1.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 11.2.0.4 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