Return
-
Title
Post error ' "row not found" and Out of sync occurs on a existing row -
Description
Post gets an out of sync error and complains "row not found". On Investigation this row exists on the target database.
-
Cause
This issue occurs when updating a col to null where col is null but this column has a not null constraint and default value.
-
Resolution
Status : Fixed in version 7.5.2.10.
-
Defect ID
ST82051 -
Additional Information
When a column is added to an existing table with default value, the default value information is only stored in oracle meta data (dictionary) and they are not present in redo log. An OOS is encountered on updating col to null where col is null and this column has not null constraint and default value.