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

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

Oracle Error Description

ORA-31520: CDC subscription string already subscribes to publication ID string

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

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

How to fix the Error ORA-31520: CDC subscription string already subscribes to publication ID 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.