|Enabling/Disabling Snapshots [message #75224]
||Wed, 24 July 2002 14:21
Registered: July 2002
Our production database creates a dataware house database using hte snapshot replication.
These snapsots are primary key snapshots and are read only. Currently everytime the data in the production database gets updated, the replication to the dataware house database happens.
We want to make the replication conditional only.
Happened to test both the following methods but none of them seem to work.
Any help please..appreciated..Is there anything else that needs to be set ?
Thanks in advance,
1) First method:
update wip_lot set lot_main_prod_id = 'Changed value' where lot_id = 'DWC_QA_5';
when others then
2) Second method:
DBMS_SNAPSHOT.SET_I_AM_A_REFRESH(value => TRUE)
DBMS_SNAPSHOT.SET_I_AM_A_REFRESH(value => FALSE);