How to fix the Oracle error ORA-31476: a change table data column is missing from the source table?

In this post, you’ll learn more about the Oracle ErrorORA-31476: a change table data column is missing from the source table with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-31476: a change table data column is missing from the source table

Reason for the Error ORA-31476: a change table data column is missing from the source table

While advancing a change set, an CDC determined that at least one of the data columns in a change table does not match the name of any of the columns in the source table. The source table column listis stored in dictionary table SYSTEM.LOGMNR_OBJ$

How to fix the Error ORA-31476: a change table data column is missing from the source table ?

You can fix this error in Oracle by following the below steps

Make sure that all of the data columns of the change table have the same names as the corresponding columns in the source table, and that all the columns exist in the source table.