Remote access with Oracle dblink global_names or without
"Without knowing how easy the item may seem difficult"
Creating a database link to point to an oracle database to another in principle is easier, if you read the post dataprix Remote access through Oracle dblink . The pity is that in this post do not say anything about the global_names of each database and rename the dblink as if global_names are active.
- We created the dblink to a dummy database hr (after having configured tnsnames ...):
create database link connect to rrhh dblinkrrhh recursoshumanos IDENTIFIED BY USING 'HR';
- Consult your name and surprise is not called if DBLINKRRHH.REGRESS.RDBMS.DEV.US.ORACLE.COM dblinkrrhh. We can see with the following query:
select * from dba_db_links;