创建db_link
-- Create database link
create database link WEBSITE.REGRESS.RDBMS.DEV.US.ORACLE.COM
connect to SEAPORTAL
using '(DESCRIPTION =(ADDRESS_LIST=(ADDRESS = (PROTOCOL = TCP)(HOST = 11.111.2.22)(PORT = 1521)))(CONNECT_DATA=(SERVICE_NAME = testdb)))';
创建同义词
-- Create the synonym
create or replace synonym COMPANY_INFO
for COMPANY_INFO@WEBSITE.REGRESS.RDBMS.DEV.US.ORACLE.COM;