Multiple SUPPLEMENTAL LOG GROUP For the same Table
(Doc ID 2138985.1)
Last updated on DECEMBER 27, 2019
Applies to:Oracle GoldenGate - Version 220.127.116.11.2 and later
Information in this document applies to any platform.
We have a table in GoldenGate configuration with 2 SUPPLEMENTAL LOG GROUP:
SQL>select * FROM DBA_LOG_GROUPS where table_name='ESITI_QF' and owner='MP_DBA'
owner log_group_name table_name log_group_type always generated
MP_DBA GGS_83952 ESITI_QF USER LOG GROUP ALWAYS USER NAME
MP_DBA GGS_13760 ESITI_QF USER LOG GROUP ALWAYS USER NAME
As you can see there are two group name of type USER LOG . How can we delete the log_group_name that is not used by extract process?
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