Question: Oracle Golden Gate sequences


Oracle Golden Gate sequences

Answers 1
Added at 2016-12-31 22:12

In Oracle Golden Gate, I'm unable to replicate production sequence to replicate database, since as sequence increased by 1 in production, the count of sequence in target increasing by 2.

Let me elaborate, suppose I have sequence with currval 190, assume after initail load, target sequence also have currval 190.

Now I booked a deal and sequence no get increased by 1 in production, currval is 191 but when i checked in target db, sequence currval showing 192. This creating issue. Need help in resolving this...

nr: #1 dodano: 2017-01-01 08:01

Did you follow below procedure for your replicate: 1. running sequence.sql in oracle sqlplus. 2.ALTER TABLE sys.seq$ ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;

Source Show
◀ Wstecz