--以物化視圖管理員身份登陸物化視圖站點
connect mvadmin/mvadmin@dbtest2 as sysdba;
--建立刷新組
begin 
dbms_refresh.make ( 
name =>'mvadmin.refresh',
list => '', 
next_date => sysdate,
interval => '/*10:Mins*/ sysdate + 10/(60*24)', 
implicit_destroy => false,
rollback_seg =>'', 
push_deferred_rpc => true,
refresh_after_errors => false); 
end;
/
--建立物化視圖組需要與主體組的名字一樣
begin
dbms_repcat.create_snapshot_repgroup(
gname => 'rep_test',
master => 'dbtest1',
propagation_mode => 'asynchronous');
end;
/
--創建實體化視圖@后面是遠程數據庫連接名。如果該表沒有主鍵則使用rowid來刷新
--創建物化視圖
--對于只讀物化視圖，省略FOR UPDATE 語句
create materialized view reptest.rep1 refresh force with rowid FOR UPDATE as select * from reptest.rep1@dbtest1;
--將物化視圖添加到物化視圖組--對于只讀物化視圖，此步驟可以省略
BEGIN
DBMS_REPCAT.CREATE_MVIEW_REPOBJECT (
gname => 'rep_test',
sname => 'reptest',
oname => 'rep1',
type => 'SNAPSHOT',
min_communication => TRUE);
END;
/
--向刷新組中添加復制對象： 
begin 
dbms_refresh.add (
name =>'mvadmin.refresh',
list =>'reptest.rep1',
lax => true); 
end; 
/
commit;