This content has been marked as final. Show 1 reply
To keep the replicated tables in sync, there should be primary key define on source and target DB.
In the absence of the PKs , a substitute key needs to be defined using SET_KEY_COLUMNS procedure of DBMS_APPLY_ADM. A substitute key is a column or set of columns that Oracle can use to identify uniquely rows in the table. This will enable APPLY to identify the row and apply the changes When using SET_KEY_COLUMNS be sure to list ALL of the key columns, in order, in the column list. Do not specify each column in a separate call to SET_KEY_COLUMNS