创建物化视图
1.在目标机建立DB Linke:
CREATE public DATABASE LINK [ dblinkname ]
CONNECT TO [dest_username ] IDENTIFIED BY [dest_pwd ]
USING 'connect_string';
CONNECT TO [dest_username ] IDENTIFIED BY [dest_pwd ]
USING 'connect_string';
PS:dblinkname : dblink 的名字;
dest_username:源机用户名;
dest_pwd:对应密码;
connect_string:tnsname.ora中的连接到源机的连接字符串;
测试:select * from [tablename]@dblink;
tablename为源机上的表;
2.在源主机建立物化视图日志(materialized view log)
create materialized view log on[mv_name] with rowid;
3.在目标机建立物化视图(materialized view)
create materialized view mv_nameREFRESH fast start with sysdate next sysdate + 2/(60*24) with rowid asselect * from tablename@dblink
PS:刷新方式为fast,当前开始,每一分钟执行1次,by rowid :