Multiple SUPPLEMENTAL LOG GROUP For the same Table (Doc ID 2138985.1)

Last updated on AUGUST 12, 2016

Applies to:

Oracle GoldenGate - Version 12.1.2.1.2 and later
Information in this document applies to any platform.

Goal

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?
 

Solution

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