-- 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)
)
)';