refresh_expected_errors_list

Use this system parameter when you want CDC Replication to ignore one or more database errors when refreshing data to the target.

The error specified must correspond to the integer error code (database-vendor specific) returned by the SQLException class in JDBC (Java™ Database Connectivity). Specify multiple errors with a comma separated list of integer error codes.

Note: Latency may increase when using this system parameter since CDC Replication will not use JDBC array apply in order to track the errors specified.

Applies to: Target datastores
Values: Specify the acceptable database errors with a comma separated list of integer error codes.; For example, if you want CDC Replication to continue refresh when it encounters primary key violations in your Oracle target database, set this parameter to mirror_expected_errors_list=1. The integer error code of 1 corresponds to the Oracle error: ORA-00001: unique constraint violated (<schema>.<constraint>). If you also want to ignore ORA-01407: cannot update (string) to NULL, set this parameter to mirror_expected_errors_list=1,1407.