...
This means that as long as there is a way on how to uniquely identify rows, replication will work as expected. Oracle will supplementally log all the columns needed.
In certain cases such as filtering, you must ensure that that column is always present in the redo logs.
Here is an example of a conditional user-defined supplemental log group for jobcode and sdate columns where ID is primary key.
| No Format | ||
|---|---|---|
| ||
ALTER TABLE AVI.SAMPLE
ADD SUPPLEMENTAL LOG GROUP sample_jobcode (ID,JOBCODE,SDATE) ALWAYS; |
The ALWAYS keyword is required to create an unconditional supplemental log group to ensure the column(s) in the filter condition are always logged in the redo log, regardless of whether they appear in the DML statement.