INSERTMISSINGUPDATES and NOINSERTMISSINGUPDATES

One of the member in the Oracle Community raised the below query. So I tested it and the solution is given below,

INSERTMISSINGUPDATES – NOINSERTMISSINGUPDATES

INSERTMISSINGUPDATES

This parameter should be added to the Replicat. It means, this is VALID only for REPLICAT Process and should be used only when the Source database logs all column values.

When this parameter is added to the Replicat file, it inserts a record based on the Source record when the target record does not exist.

This means, If a record is updated in Source, On the target the same record will be inserted if the record does not exists instead a missing record error or REPLICAT ABEND.
This parameter also supports the database which is using the COMPRESSED form of updates (where only changed values are logged instead of logging all columns) provided that the NULL can be used for missing column values on the target database.

NOINSERTMISSINGUPDATES

This parameter is a default one. When this is in place, whenever a record is updated on the Source side, and that record is not present in the Target then this leads to a Missing Record Error and the Transaction might ABEND depending on the REPERROR parameter setting in the REPLICAT file.

In General, these parameters are specific to tables. A single parameter will be in effect for all the MAP statements until the other parameter is detected or encountered by the Process.

The below example shows how the INSERTMISSINGUPDATES works.,

I have used the INSERTMISSINGUPDATES in my Replicat Parameter File.

ON SOURCE

Check the records on the Source table.

ON TARGET

Now I am going to delete a record on the Target Side,.

Check if the record has been deleted or not.,

Now in Target we have only 4 rows. One row is deleted. Now I am going to process an update in the source side in the row which I have deleted in the Target side.

ON SORUCE

The records on the Source is as below,

Now update the record.,

Check if the update has been reflected.,

ON TARGET

Check the rows on the target table.

You can see the row which I have updated in Source has been inserted in Target side..

CONCLUSION

INSERTMISSINGUPDATES – Using this parameter we can handle the Missing record error on the TARGET – REPLICAT.

We can clearly see that, whenever an update is made in the SOURCE, the record got inserted in the TARGET table, eventhough it was not present in the TARGET table.