create db link w/o modifying tnsnames.ora - Oracle Database Script. CREATE PUBLIC DATABASE LINK IMFP CONNECT TO iwf IDENTIFIED BY thr3iwf USING '(DESCRIPTION=(ADDRESS_LIST=( ADDRESS=(PROTOCOL=TCP)(HOST=testoracle.com)(PORT=1522))) (CONNECT_DATA=(SERVICE_NAME=IMFP)))';
CREATE PUBLIC DATABASE LINK IMFP CONNECT TO iwf IDENTIFIED BY thr3iwf USING '(DESCRIPTION=(ADDRESS_LIST=( ADDRESS=(PROTOCOL=TCP)(HOST=testoracle.com)(PORT=1522))) (CONNECT_DATA=(SERVICE_NAME=IMFP)))';