Create DBLINK

CREATE DATABASE LINK fremoteorcl
   CONNECT TO jnp_inv_rmpm_b IDENTIFIED BY jnp_inv_rmpm_b
   USING 'orcl122';

drop database link FREMOTE10G

----created 

CREATE PUBLIC DATABASE LINK "FREMOTE10G"
   CONNECT TO "JPLDBA" IDENTIFIED BY VALUES 'j'
   USING 'orcl10g';

   desc jnp_inv_rmpm_b.company@fremoteorcl
 
   desc COMPANY_INFO
   select * from tab;
   select * from jnp_inv_rmpm_b.company@fremoteorcl