GoldenGate: Enable supplemental logging for tables upon their recreation

Assuming that minimal supplemental logging is enabled at database level with

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

include following instructions to your table creation script to enable GoldenGate capture all changes from the fresh start of your tables life:
If the table has a primary key:

ALTER TABLE xxx ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;

If the table doesn’t have a primary key and have a unique index:

ALTER TABLE xxx ADD SUPPLEMENTAL LOG GROUP (first unique index columns) ALWAYS;

If the table doesn’t have a primary key or a unique index or if it has a manipulation or a filter defined on columns that are not part of the PK:

ALTER TABLE xxx ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;

Taken from this forum