Retour
-
Titre
How do Change History or Change Data Capture (CDC) handle ROLLBACK -
Description
How do Change History or Change Data Capture (CDC) handle ROLLBACK
-
Cause
General information. -
Résolution
The CDC target does not log ROLLBACK as opposed to the COMMIT. This is different from any DELETE, UPDATE, INSERT or COMMIT occurring on source which are logged in the target CDC table (as shown for INSERT and COMMIT below):
One plausible explanation for this design is, the CDC target only records what fruitful DMLs (in addition to COMMIT) occurred on source. The ROLLBACKs do not fall under such realm.