-- Drop existing database link drop database link daimami.com.RDBMS.DEV.US.ORACLE.COM; -- Create database link create database link daimami.com.RDBMS.DEV.US.ORACLE.COM connect to daimami identified by pass using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.1)(PORT = 1521)) ) (CONNECT_DATA = (SID = orcl) ) )';