How to fix the Oracle error ORA-31535: cannot support change source string in this configuration?

In this post, you’ll learn more about the Oracle ErrorORA-31535: cannot support change source string in this configuration with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-31535: cannot support change source string in this configuration

Reason for the Error ORA-31535: cannot support change source string in this configuration

Each database can only have one change source with hot mine option enabled. The system detected an existing hot mine change source in the database, therefore, a second hot mine change source cannot be created.

How to fix the Error ORA-31535: cannot support change source string in this configuration ?

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

Remove the existing change source and create this new change source again.