临海小憇

标题: 创建DB link以及同义词 [打印本页]

作者: lake 时间: 2018-7-25 19:33
标题: 创建DB link以及同义词

create database link Dblink
connect to xxx identified by xxxx
  using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 1111111)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = orcl)))';


create or replace synonym cccc for xxxxx.tableName@DBLINK;

create or replace synonym cccc for xxxxx.tableName

欢迎光临临海小憇 (http://www.czidea.cn/)