Home » Server Options » Replication » Replication - Data missing .........
Replication - Data missing ......... [message #74997] Mon, 29 January 2001 12:37 Go to next message
Suresh.N
Messages: 41
Registered: March 2000
Member
Hi!

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
Suresh.N

----------------------------------------------------------------------
Re: Replication - Data missing ......... [message #74999 is a reply to message #74997] Tue, 30 January 2001 22:10 Go to previous message
Eddie
Messages: 23
Registered: January 2001
Junior Member
Hi,

Why don't you try a synchronous replication?

It is strange that the data are missing... They shouldn't change till the refresh takes place.

Best Regards,
Edward Hayrabedian

----------------------------------------------------------------------
Previous Topic: ORACLE REPLICATION
Next Topic: Updatable Snapshots - PLEASE HELP! -
Goto Forum:
  


Current Time: Fri Apr 19 20:46:49 CDT 2024