一、环境描述
源端:OracleRAC12c
目标端:OracleRAC19c
本案例测试的是私有的dblink,若需求为公有,请添加Public关键字
二、创建dblink
目标端操作
create user TEST19C identified by 123;
grant connect,resource to TEST19C;
grant create table to TEST19C;
grant unlimited tablespace to TEST19C;
源端操作
1、首先创建测试用户
create user TEST12C identified by 123;
2、给该用户添加权限
grant connect,resource to TEST12C;
grant create database link to TEST12C;
grant drop database link to TEST12C;
3、在该用户下创建dblink
sqlplus / as sysdba
conn TEST12C/123
CREATE DATABASE LINK Pri_19c_TestLink CONNECT TO TEST19C IDENTIFIED BY “123” USING ‘(DESCRIPTION=(ADDRESS = (PROTOCOL = TCP)(HOST = 10.30.150.200)(PORT = 1910))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = acscnprd)))’;
三、测试dblink
目标端操作
sqlplus / as sysdba
conn TEST19C/123
create table test(id number);
insert into test19c values(200);
commit;
源端操作
select * from test@Pri_19c_TestLink;
ID
200
insert into test19c@Pri_19c_TestLink values(300);
commit;
select * from test@Pri_19c_TestLink;
ID
200
300
测试完成!
四、删除dblink
源端操作
sqlplus / as sysdba
conn TEST12C/123
drop database link Pri_19c_TestLink;