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.

Share:

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

Oracle Error Message ORA-24328: illegal attribute value Reason for the Error The attribute value passed in is illegal. Solution Consult...
Oracle Error Message ORA-01346: LogMiner processed redo beyond specified reset log scn Reason for the Error LogMiner has detected a...
Oracle Error Message ORA-13241: specified dimensionality does not match that of the data Reason for the Error An error occurred...