-- Drop existing database link
drop database link ZJDATA.REGRESS.RDBMS.DEV.US.ORACLE.COM;
-- Create database link
create database link ZJDATA.REGRESS.RDBMS.DEV.US.ORACLE.COM
connect to ZJDATA Identified ZJDATA
using '(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.218.10.8)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.218.10.9)(PORT = 1521))
(LOAD_BALANCE = NO)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)';
drop database link ZJDATA.REGRESS.RDBMS.DEV.US.ORACLE.COM;
-- Create database link
create database link ZJDATA.REGRESS.RDBMS.DEV.US.ORACLE.COM
connect to ZJDATA Identified ZJDATA
using '(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.218.10.8)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.218.10.9)(PORT = 1521))
(LOAD_BALANCE = NO)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)';