How to fix the Oracle error ORA-31518: change column string already exists in CDC change table string.string?

In this post, you’ll learn more about the Oracle ErrorORA-31518: change column string already exists in CDC change table string.string with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-31518: change column string already exists in CDC change table string.string

Reason for the Error ORA-31518: change column string already exists in CDC change table string.string

A column in a Change Data Capture change table intended for import was already present in the change table.

How to fix the Error ORA-31518: change column string already exists in CDC change table string.string ?

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

Either verify that the change table contains the desired columns or drop the change table and perform the import again.