Example for creating dblink in Oracle.

You should change all things that bolded:

create public database link TEST
connect to username identified by password
 using
'(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(Host=IP or hostname)(Port=1521)))(CONNECT_DATA=(SID=TEST)))'

If you would like to drop link, you can use follow:

drop public database link TEST