GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

How to change PK columns after GoldenGate set up

edited Mar 6, 2015 10:02AM in GoldenGate, Streams and Distributed Database (MOSC) 3 commentsAnswered

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center