创建数据库连接和同义词

 

创建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 [e-mail];