How to auto replicate Oracle Sequence with Oracle Streams
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: How to auto replicate Oracle Sequence with Oracle Streams

  1. #1
    Join Date
    Mar 2007
    Posts
    21

    How to auto replicate Oracle Sequence with Oracle Streams

    Hi All,

    I facing a problem when using Oracle Streams. The Sequences (use for primary key) in Source DB is increasing, but in Destination DB is not increasing.

    When Source DB is shutdowned, I changed Application to Dest DB but when inserting, Primary key is violated because of Sequences in Dest DB. We can not change Application code or Alter Sequence at Dest DB because there are a lot of Sequence.

    Are there any way to auto replicate Sequences when using Oracle Streams?

    Please help me.
    Thanks.

  2. #2
    Join Date
    Oct 2017
    Posts
    1
    Hi friend,
    The sequences are not replicated basically, and it is better.
    You can use odd numbered sequences - incremented by 2 every time like 1, 3, 5, 7 - on one DB,
    and even numbered sequences on the second DB (2, 4, 6, 8 etc.).

    Regards,
    Alex

Posting Permissions

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


Click Here to Expand Forum to Full Width