Creating a DBLINK on oracle with explicit TNS information

If you have tried to create an Oracle dblink, and you get the following error message;

*********************************************************************

Link  : "DBLINK_NAME"

Error : ORA-12154: TNS:could not resolve the connect identifier specified

*********************************************************************

then it means that the tns entry to the database you connecting to, does not exist. You could ask the dba to add the entry for you, otherwise you can use the following statement.

 CREATE DATABASE LINK dblink_name
CONNECT TO schema_name IDENTIFIED BY password
USING '(DESCRIPTION=
    (ADDRESS=
      (PROTOCOL=TCP)
      (HOST=)
      (PORT=)
    )
    (CONNECT_DATA=
      (SERVER=dedicated)
      (SERVICE_NAME=)
    )
  )'