我建了一个for update的simple snapshot
现在如果修改后再refresh就会报错
sql> execute dbms_snapshot.refresh('apply_mid_snap')
ORA-12008: error in materialized view refresh path
ORA-02064: distributed operation not supported
ORA-02063: preceding line from KFYD
文档说
When used in conjunction with the Replication Option, these updates will be propagated to the master.
具体要怎么做，才能将修改提交到主表？
补充测试过程
SQL> create snapshot apply_mid_snap
2 tablespace yd_data
3 using index tablespace indx
4 refresh fast
5 start with trunc(sysdate)+1
6 next trunc(sysdate)+1+1/144
7 for update
8 as select * from apply_mid@kfyd
9 /
Snapshot created.
SQL> execute dbms_snapshot.refresh('apply_mid_snap')
PL/SQL procedure successfully completed.
SQL> update apply_mid_snap set hm = 'aa' where rownum = 1
2 /
1 row updated.
SQL> commit;
Commit complete.
SQL> execute dbms_snapshot.refresh('apply_mid_snap')
begin dbms_snapshot.refresh('apply_mid_snap'); end;
*
ERROR at line 1:
ORA-12008: error in materialized view refresh path
ORA-02064: distributed operation not supported
ORA-02063: preceding line from KFYD
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 794
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 851
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 832
ORA-06512: at line 1
