DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: sequence numbers in replication

  1. 02-12-2001, 11:42 AM #1
    chikkodi
    chikkodi is offline Member
    Join Date
    Jan 2001
    Posts
    216
    We have Master-Master replication setup and our database contains a couple of sequences. When I tried to replicate them, it gave me an error. I looked at the replication API document, it did not list "sequences" as one of the currently supported features in replication.

    Can you suggest me a good way to solve this ? We just have two databases being Master-Master replicated.

    Thanks a lot for your help.
    Reply With Quote Reply With Quote
  2. 02-12-2001, 05:50 PM #2
    nw1234
    nw1234 is offline Junior Member
    Join Date
    Oct 2000
    Posts
    10
    OAR does not support Sequences in replication. One way to approach this is to have each site generate a globally unique sequence. for Example, Node A's sequences start with 1 and increment by 2 (All Odds) and Node B's sequences start with 2 and increment by 2 (all Even).

    Hope that helps...

    Reply With Quote Reply With Quote
  3. 02-13-2001, 11:56 AM #3
    chikkodi
    chikkodi is offline Member
    Join Date
    Jan 2001
    Posts
    216
    Thanks a lot for the good solution.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width