How To Configure Goldengate Replicat to use RANGE function for Parent and Child Tables?
Last updated on JULY 17, 2017
Applies to:Oracle GoldenGate - Version: 18.104.22.168.0
Information in this document applies to any platform.
Parent table P1: col1 primary key, col2
Child table C1: col3 primary key, col4, col1 not null (col1 is FK on P1(col1)).
There is no update to change the values of P1.col1, and C1.col1.
When configuring replicats with RANGE function as following, they abend:
map p1, target p1, filter (@range (1,2));
map c1, target c1, filter (@range (1,2));
map p1, target p1, filter (@range (2,2));
map c1, target c1, filter (@range (2,2));
Is there a solution for this?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms