Supplemental Logging Values Changing After Registering Extract
(Doc ID 2668631.1)
Last updated on MAY 25, 2020
Applies to:Oracle GoldenGate - Version 220.127.116.11.2 and later
Information in this document applies to any platform.
Facing below issue with goldengate on source database.
Versions: Oracle Goldengate : 18.104.22.168.4, Database : 22.214.171.124.0 (multitenant database);
- Implemented trandata at table level for all columns
- Created common user with all necessary privileges at root level (C##<username>)
Before Integrated Extract is registered with PDB, below are values from "CDB_SUPPLEMENTAL_LOGGING"
After enabling minimal supplemental logging, minimal supplemental logging is YES; and PRIMARY_KEY, UNIQUE_INDEX, FOREIGN_KEY are: NO for the PDB
but after registering extract, supplemental logging of PRIMARY_KEY, UNIQUE_INDEX, FOREIGN_KEY are changed to: YES.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document