How to fix the Oracle error ORA-31516: CDC change set string already exists?

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

Oracle Error Description

ORA-31516: CDC change set string already exists

Reason for the Error ORA-31516: CDC change set string already exists

A Change Data Capture change set intended for import already existed.

How to fix the Error ORA-31516: CDC change set string already exists ?

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

Either verify that the existing change set has the desired characteristics or drop the existing change set and perform the import again.