1 创建dblink create dblink to_db2 connect to user identified by password using db2 insert into 无数据表 select * from 有数据表@to_db2 where 日期='某天'2 使用物化视图 materialized view
在DATABASE1中原用户user1/user1pas,DATABASE2中原用户user2/user2pas 1。在DATABASE1中建user2/user2pas,授权user2可以访问user1要复制的表的权限。 2。DATABASE1中建DBLINK: CREATE DATABASE LINK dblink1 CONNECT TO user2 IDENTIFIED BY user2pas USING database2; 3。DATABASE2中user2登录: select * from 有数据表@dblink1 where 日期='某天'
create dblink to_db2 connect to user identified by password using db2
insert into 无数据表 select * from 有数据表@to_db2 where 日期='某天'2 使用物化视图 materialized view
@DBLINKname 能不能写详细一些
1。在DATABASE1中建user2/user2pas,授权user2可以访问user1要复制的表的权限。
2。DATABASE1中建DBLINK:
CREATE DATABASE LINK dblink1 CONNECT TO user2 IDENTIFIED BY user2pas USING database2;
3。DATABASE2中user2登录:
select * from 有数据表@dblink1 where 日期='某天'