Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PK UK Supplemental Logging

kazyskiyn0wAug 4 2016 — edited Aug 5 2016

HI All,

We have Golden Gate 12c and we are implementing classical replication. We cannot implement integrated replication.

For Unique Key and Primary key supplemental logging configuration, I have a doubt if running the below commands are enough or do I have to run other commands

sqlplus / as sysdba

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA(PRIMARY KEY) COLUMNS;

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA(UNIQUE) COLUMNS;

ALTER DATABASE FORCE LOGGING;

Thank you.

Kz

This post has been answered by 2897761 on Aug 4 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 2 2016
Added on Aug 4 2016
7 comments
717 views