Remote access with Oracle dblink global_names or without

By il_masacratore on Mon, 08/02/2010 - 06:28

"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.

Example.

  1. 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';
  2. 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;

    Now what?

Prueba Semrush gratis 14 días!