Database constraints

CDC Replication supports constraints on target tables under the certain conditions.

The following conditions exist:

• Constraints on the target system must be the same or less restrictive than the source system.
• When constraint checking is deferred on the source database, the deferred constraints should be removed from the target system to enable the product to run correctly.

You can defer constraints in your database with one of the following methods:

• A user manually defers the constraints
• An update of KEY = KEY + 1. For example, UPDATE TABLE SCOTT.EMP SET EMPNO = EMPNO + 1;
• Cascading deletes