How to fix the Oracle error ORA-31521: CDC subscription string already subscribes to publication ID string column string?

In this post, you’ll learn more about the Oracle ErrorORA-31521: CDC subscription string already subscribes to publication ID string column string with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-31521: CDC subscription string already subscribes to publication ID string column string

Reason for the Error ORA-31521: CDC subscription string already subscribes to publication ID string column string

A Change Data Capture subscription intended for import already subscribed to a published column.

How to fix the Error ORA-31521: CDC subscription string already subscribes to publication ID string column string ?

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

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