Multiple SUPPLEMENTAL LOG GROUP For the same Table
Last updated on AUGUST 12, 2016
Applies to:Oracle GoldenGate - Version 126.96.36.199.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?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms