Code: Select all
--
-- Definition for database link "DB2GW.WORLD"
--
DROP DATABASE LINK "DB2GW.WORLD";
CREATE DATABASE LINK "DB2GW.WORLD"
CONNECT TO PSRP01 IDENTIFIED BY /*Encrypted password*/
USING '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(PORT=1526)(HOST =111.11.111.11))
(CONNECT_DATA=(SID=g))(HS=))';
Also, it would be nice if dbForge could open the file it creates. Luckily there are programs that can. I could definitely see it not highlighting and giving intellisense but at least let us open it and goto line for debugging purposes. LTF Viewer works well for this but my wish would be to do it without another tool