Home » Server Options » Replication » Enabling/Disabling Snapshots
Enabling/Disabling Snapshots [message #75224] Wed, 24 July 2002 14:21
Sangita
Messages: 4
Registered: July 2002
Junior Member
Enabling/Disabling Snapshots:

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,
Sangita.

1) First method:

begin
dbms_reputil.replication_off;

update wip_lot set lot_main_prod_id = 'Changed value' where lot_id = 'DWC_QA_5';
commit;

dbms_reputil.replication_on;
exception
  when others then
    dbms_output.put_line('Error');
end;

2) Second method:
DBMS_SNAPSHOT.SET_I_AM_A_REFRESH(value => TRUE)
update........columns...
DBMS_SNAPSHOT.SET_I_AM_A_REFRESH(value => FALSE);
Previous Topic: Master Definition Site Restoration
Next Topic: Want to generate support for 80 GB Data
Goto Forum:
  


Current Time: Wed May 18 01:48:24 CDT 2022