Bi-Directional MISSING Column gap fill.

Dear All,

I have a requirement from client in my Bi-Directional replication environment, to insert missing records from opposite replicating database.

Prior to replication setup a merge statement was being used by client to overcome such scenario in primary database.

After replication setup, the requirement is,

Sample table structure is given for understanding purpose.

Site A has table BDDATA.AWBMST.

Site B has table BDDATA.AWBMST.

Both the tables have similar structure, and assumetargetdefs are used.

Table Structures:-

Source                                                       Target

BDDATA.AWBMST                                     BDDATA.AWBMST

ID                      NUMBER                           ID                    NUMBER

NAME               VARCHAR2                        NAME             VARCHAR2

STATUSCODE   NUMBER                           STATUSCODE NUMBER

ADDRESS         VARCHAR2                        ADDRESS       VARCHAR2