Updateble snapshot push and refresh

Hi,

I have a strange case with an updateble snapshot:

• 2 databases SNAP and MAST
• a table table1 (id number primary key, name varchar2(30)) on the master site
• I've configured replication on both the master and the snapshot sites
• On the snapshot site, the refresh group was created like this:

BEGIN
DBMS_REFRESH.MAKE(
name => '"SNAP_REP_GRP2"',
list => '',
next_date => SYSDATE,
interval => 'sysdate + 2/1440',
push_deferred_rpc => FALSE,
refresh_after_errors => TRUE,
parallelism => 0);
END; 1- a "select * from table1" gives the result (1, 'A')

2- on the snapshot site: update table1 set name='B' where id=1; commit;

3- on the snapshot site I have the values (1, 'B') and on the master site, I have the values (1, 'A')

4- on the snapshot site:

   begin
   dbms_refresh.refresh('SNAP_REP_GRP2');    end;

on the snapshot site I have the values (1, 'A') and on the master site, I have the values (1, 'A')

5- on the snapshot site:

   declare rc binary_integer;
   begin rc := sys.dbms_defer_sys.push(destination=>'MAST.WORLD');    end;        

on the snapshot site I have the values (1, 'A') and on the master site, I have the values (1, 'B')

6- on the snapshot site:

   begin
   dbms_refresh.refresh('SNAP_REP_GRP2');    end;

on the snapshot site I have the values (1, 'B') and on the master site, I have the values (1, 'B')

But if I do the push before the refresh, every thing is ok.

Thank you. Received on Wed Jan 23 2002 - 04:36:00 CST