When using a hot/hot environment with GoldenGate, it is necessary to avoid PK collisions. The standard approach is for one side to use even numbers and the other to use odd. Here’s a script that will change all the sequences within a schema to either even or odd: DECLARE PROCEDURE set_sequence (i_owner IN VARCHAR2, i_sequence […]