Update on snapshot target overwritten after fast refresh

I created master/slave snapshot (9.2.0) with the slave side updateable. This is not a master to master configuration as I do not want the change on slave side reflected back to the master.

I tried to create both the snapshot log and snapshot with primary key, rowid or no option at all, but in any of the above cases, my changes on the slave site will be gone after a fast refresh.

It looks like as if the refresh were complete, although I did specify "fast" in the creation.

On master I did this:

create snapshot log on push_tbl;

On the slave I did this:

create snapshot push_tbl refresh fast start with sysdate next sysdate+(1/288) using rollback segment big for update as select * from push_tbl_at_se80;

Does anybody know why it behaves this way ? Thanks. Received on Wed Nov 06 2002 - 18:40:57 CST