CREAR DBLINK EN DATABASE ORACLE

DB LINK

1. Primero debemos abrir el tnsname.
2. Entramos al tnsname y creamos la conexión.

SQL> desc DBA_DB_LINKS
 Name                                      Null?                              Type
 ----------------------------------------- -------- ----------------------------
 OWNER                                     NOT NULL      VARCHAR2(30)
 DB_LINK                                   NOT NULL       VARCHAR2(128)
 USERNAME                                                                 VARCHAR2(30)
 HOST                                                                          VARCHAR2(2000)
 CREATED                                   NOT NULL     DATE

O lo editamos

Creamos el DBLINK

Create public/private database_link linkname connect to username identified by Password using ‘Service Name’; i

Ejemplo:

Create DBLINK

CREATE PUBLIC DATABASE LINK "TESTING" CONNECT TO USER IDENTIFIED BY PASSWORD USING 'TESTING.WORLD’;

La configuración de nuestro TNSNAME es :


TESTING.WORLD
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.170.68.83)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = SXXX
      (SERVER = TEST)
    )
  )

sqlplus  / as sysdba

CREATE public DATABASE LINK NAMELINK CONNECT TO USERLINK IDENTIFIED BY password USING
'(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname.domainname.com)(PORT=1521)))
(CONNECT_DATA=(SID = SXXX')));


Chequeamos el DB link :

select * from dual@NAMELINK;

Select * from dba_db_links;


DROP DBLINK:

DROP PUBLIC DATABASE LINK "NAMELINK.WORLD";