| 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);
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
