知识要点

创建DBLink

创建DBLink

实验环境
192.168.132 sky2 scott
192.168.133 sky3 king 配置tnsname o133

1. 授予创建权限
   sys>grant create database link to king;
   king>create database link d133 connect to scott identified by tiger using ‘o133’;
   king>select * from emp@d133;

2. 创建同义词
   create synonym emp for emp@d137;

3. 拓展 set arraysize 1000; 拷贝scott下的emp表到king下empxxx copy from scott/tiger@sky2 to king/123@sky3 create empxx using select * from emp;