supplemental logging configuration for GGS
1. What is the difference in Oracle 11g R2 table supplemental logging types: 'USER LOG GROUP' vs 'ALL COLUMN LOGGING' ... where both types are defined by ALWAYS=ALWAYS per the DBA_LOG_GROUPS table.
GOAL: correctly validate table logging attributes for Golden Gate configuration
2. What is correct difference between:
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
vs
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (ALL) COLUMS
3. To replicate all rows for all DML to another schema, what is correct "table supplemental log type" command:
a. ALTER TABLE [table_name] ADD SUPPLEMENTAL DATA (ALL) COLUMNS
-or-
b. ALTER TABLE [table_name] ADD SUPPLEMENTAL LOG GROUP table_set (id,name,date,desc) ALWAYS;