DB_LINK

CREAR UN DBLINK

CREATE PUBLIC DATABASE LINK "DBLINK_nombre.midominio.com"

CONNECT TO NOM_USER

IDENTIFIED BY "password"

USING '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST =XX.XX.XX.XX)(PORT = 1521)) ) (CONNECT_DATA = (SID = sid_BD)))';

Consultar DB_LINK

select * from NOM_TABLA@NOM_DBLINK.dominio.com;

ELIMINAR UN DBLINK

DROP PUBLIC DATABASE LINK "DBLINK_nombre.midominio.com";

Pasar undato tipo CLOB por dblink

select (select <columnName> from dual) <columnName> from <table>@<link>

select (select COLUMNA_TABLE_JSON from dual) COLUMNA_TABLE_JSON from TABLE_JSON@DBLINK_nombre.midominio.com;