Supplemental Logging
For streams, one of the requirements as per the manual is enabling supplemental logging. I have enabled the same at the DB level using:
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (UNIQUE) COLUMNS;
I want to have a schema to schema (1-to-1) streams replication. Is it also necessary to create an unconditional log group and add each table of the schema to this group again using:
ALTER TABLE EMP1 ADD SUPPLEMENTAL LOG GROUP s_log_grp (emp_unique) ALWAYS;
The schema tables only have unique keys and no primary keys.
Thanks.