Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Dbvisit Replicate does not update target Oracle sequences.

It does replicate the sequence value that is inserted into the source data from the Oracle sequences (normally a primary key).

So the end result is that the primary key values will be the same on both source and target.

For active-active replication it is necessary to ensure that the sequences do not collide with each other. The way to do that is to set one sequence to only even numbers and the other to only odd numbers. Or to have one sequence start from 1 and the other count down from a large number. 

  • No labels