oracle stream不会同步sequence值的变化如何解决

oracle stream不会同步sequence值的变化如何解决

 

oracle stream可以同步sequence的创建和变更, 但不会同步sequence
值的变化,如a_seq.nextval在备份库是不会执行的,
因为stream同步的是dml的内容 

 

如何解决sequence的主备上不一致呢? 

 

1,主备机上定义sequence时,永远不会重叠 

1st : start with 1 increment by 2 

2nd: start with 2 increment by 2 

 

2,独立区间 

1st : start with 1 increment by 2 end with 10000 

2nd: start with 10001 increment by 2