How to change PK columns after GoldenGate set up
Hello,
After setup Golden Gate replication, there is business need to change the PK columns. How to implement this?
For example, for table T1 which is replicated by PK on column C1. Now we want to create a new PK on column C2 and C3, then drop (or set unused) column C1. There is always the error as
ORA-12991: column is referenced in a multi-column constraint
Because
OWNER LOG_GROUP_NAME TABLE_NAME COLUMN_NAME POSITION LOGGIN
------------------------------ ------------------------------ ------------------------------ --------------------------------------------- ---------- ------
FPA GGS_296243 T1 C1 1 LOG
FPA GGS_296243 T1 C2 2 LOG
FPA GGS_296243 T1 C3 3 LOG
What is the solution for such change in Golden Gate environment?