dblink

 1 create public database link <linkname> connect to <user> identified by "<password>"
 2 using '(DESCRIPTION =
 3     (ADDRESS_LIST =
 4       (ADDRESS = (PROTOCOL = TCP)(HOST = <IP>)(PORT = 1521))
 5     )
 6     (CONNECT_DATA =
 7       (SERVICE_NAME = <orcl>)))'
 8     
 9     
10 SELECT * FROM <user>.<table_name>@<linname>
11 
12 
13 
14 
15 select *  from dba_db_links where db_link='<dblink_name>'
16 
17 DROP PUBLIC DATABASE LINK '<dblink_name>';

select owner,object_name from dba_objects where object_type='DATABASE LINK';

drop public database link LINK1