Home » Server Options » Replication » changing the sequence number of replicated data
changing the sequence number of replicated data [message #75076] Wed, 25 July 2001 19:49 Go to next message
buntie
Messages: 1
Registered: July 2001
Junior Member
I am getting deferred trxs on replication to master site because the value exist in the master table, how can I change the sequence number of the data going into the master table

----------------------------------------------------------------------
Re: changing the sequence number of replicated data [message #75077 is a reply to message #75076] Thu, 26 July 2001 20:01 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Probably the best way is to "partition" your existing sequence number generator e.g. so that Server A users 0-500000 and Server B uses 500001-999999. Alternately you could set the seq gererators to have an increment of 2 and use even numbers on one server and odd on the other.

----------------------------------------------------------------------
Previous Topic: Replication tables which using context search (ORA-12008)
Next Topic: RE: Trigger in Replicated Database
Goto Forum:
  


Current Time: Fri Oct 30 00:37:40 CDT 2020