OGG-01409
Unable to detect missing target row for update for table {0} because there are no modifiable columns, at RBA {1,number,0}, in file {2}. NOCOMPRESSUPDATES may be specified in the EXTRACT parameter file to include a complete image for update operations.
Cause
Replicat could not perform the update, probably because the source and target tables do not have a primary or unique key (or a KEYCOLS clause) and, therefore, Replicat could not locate the target row. By default, Extract only writes the primary key, unique key, or KEYCOLS columns to the trail (plus the changed columns), which provides enough information for the Replicat SQL operation for updates. However, without a key, Replicat only has the change data, which is not enough.
Action
You can do one of the following: Use the Extract NOCOMPRESSUPDATES parameter to send all of the columns to the trail, so that when a table definition does not include a primary key or unique index, Replicat can use all of the columns as a key. Alternatively, you can define a substitute key for the table by using a KEYCOLS clause in the TABLE parameter.
OGG-01409
Unable to detect missing target row for update for table {0} because there are no modifiable columns, at RBA {1,number,0}, in file {2}. NOCOMPRESSUPDATES may be specified in the EXTRACT parameter file to include a complete image for update operations.
Cause
Replicat could not perform the update, probably because the source and target tables do not have a primary or unique key (or a KEYCOLS clause) and, therefore, Replicat could not locate the target row. By default, Extract only writes the primary key, unique key, or KEYCOLS columns to the trail (plus the changed columns), which provides enough information for the Replicat SQL operation for updates. However, without a key, Replicat only has the change data, which is not enough.
Action
You can do one of the following: Use the Extract NOCOMPRESSUPDATES parameter to send all of the columns to the trail, so that when a table definition does not include a primary key or unique index, Replicat can use all of the columns as a key. Alternatively, you can define a substitute key for the table by using a KEYCOLS clause in the TABLE parameter.
OGG-01409
Unable to detect missing target row for update for table {0} because there are no modifiable columns, at RBA {1,number,0}, in file {2}. NOCOMPRESSUPDATES may be specified in the EXTRACT parameter file to include a complete image for update operations.
Cause
Replicat could not perform the update, probably because the source and target tables do not have a primary or unique key (or a KEYCOLS clause) and, therefore, Replicat could not locate the target row. By default, Extract only writes the primary key, unique key, or KEYCOLS columns to the trail (plus the changed columns), which provides enough information for the Replicat SQL operation for updates. However, without a key, Replicat only has the change data, which is not enough.
Action
You can do one of the following: Use the Extract NOCOMPRESSUPDATES parameter to send all of the columns to the trail, so that when a table definition does not include a primary key or unique index, Replicat can use all of the columns as a key. Alternatively, you can define a substitute key for the table by using a KEYCOLS clause in the TABLE parameter.
