Oracle Error ORA-31480: staging database and source database cannot be the same

Oracle Error Message

ORA-31480: staging database and source database cannot be the same

Reason for the Error

A CDC API call specified a source database name that matched the staging database on which the CDC API call is being executed.

Solution

Make sure that the CDC API call is being executed from the staging database and that the source database is correctly specified. The source database and staging database need to be different databases.