dblink

create public database link <linkname> connect to <user> identified by "<password>"
using '(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = <IP>)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = <orcl>)))'
    
    
SELECT * FROM <user>.<table_name>@<linname>




select *  from dba_db_links where db_link='<dblink_name>'

DROP PUBLIC DATABASE LINK '<dblink_name>';

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

drop public database link LINK1