I have some problem in replication.
I have two database called DB1 and DB2.
I have one table called T1 in DB1.
I created a snapshot T2 in DB2 for T1 by using Database Link.
I have sheduled the refresh group for every 5 seconds.
I have created one Scheduled link for my database link every 5 secconds.
Now I can able see the data from DB1.T1 through DB2.T2 snapshot.
And the refreshing is also working fine.
The problem is every five seconds it refresh the data.
So when I select the data from DB2.T2 some times data missing. It comes after few seconds...
I think for that refreshing it remove the data from DB2.T2 and again inserts.
So I could't see the data continousely.
Can you please help me out this...
Thanks and Regards
what kind of refresh are you doing: fast or complete? Try fast.
(To simplify things, try setup w/o groups first, just table-to-table.)
I don't think its deleting the data while refreshing it.
Defeats the purpose of replication!!
Fast refresh is one option, you can also use the parrallel option.
it is definetly deleting data.
Now I forgot, but I believe that in complete refresh mode it just truncates table => for a while another session see zero rows.
Can be easily tested with dbms_snapshot.refresh(,, 'C')
Click Here to Expand Forum to Full Width