I have 2 oracle databases (db1 and db2) on different machines, lets suppose: db1 on 192.168.1.1 and db2 on 192.168.1.2
What I want to achieve is to create a link on db1 that will allow me to perform queries on db2.
This is the way I created the link on db1:
create public database link db2Link connect to db2username identified by db2password using 'db2';
I think this should work if both that bases are on the same machine, but as I want to connect to a database that is on a different machine, how can I do that link?
Thanks Best Regards