drop database link LINK_NAME.US.ORACLE.COM;
-- Create database link
create database link LINK_NAME.US.ORACLE.COM
connect to ZZY identified by ZZY
using '(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = CHINA-5BF855638)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)';
-- Create database link
create database link LINK_NAME.US.ORACLE.COM
connect to ZZY identified by ZZY
using '(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = CHINA-5BF855638)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)';