Oracle Database Errors or Warnings from Error ORA-31516 to ORA-31525

SQLServerF1

ORA-31516: CDC change set string already exists
Cause: A Change Data Capture change set intended for import already existed.
Action: Either verify that the existing change set has the desired characteristics or drop the existing change set and perform the import again.
ORA-31517: CDC change table string.string already exists
Cause: A Change Data Capture change table intended for import already existed.
Action: Either verify that the existing change table has the desired characteristics or drop the existing change table and perform the import again.
ORA-31518: change column string already exists in CDC change table string.string
Cause: A column in a Change Data Capture change table intended for import was already present in the change table.
Action: Either verify that the change table contains the desired columns or drop the change table and perform the import again.

ORA-31519: CDC subscription string already exists
Cause: A Change Data Capture subscription intended for import already existed.
Action: Either verify that the existing subscription has the desired characteristics or drop the existing subscription and perform the import again.
ORA-31520: CDC subscription string already subscribes to publication ID string
Cause: A Change Data Capture subscription intended for import already subscribed to a publication.
Action: Either verify that the existing subscription has the desired characteristics or drop the existing subscription and perform the import again.
ORA-31521: CDC subscription string already subscribes to publication ID string column string
Cause: A Change Data Capture subscription intended for import already subscribed to a published column.
Action: Either verify that the existing subscription has the desired characteristics or drop the existing subscription and perform the import again.

ORA-31522: could not find Streams object string for CDC change set string
Cause: An underlying Streams capture, apply, or queue was missing for an imported Change Data Capture change set.
Action: Drop the imported change set because it is invalid. Retry the import, ensuring that STREAMS_CONFIGURATION=y is specified.
ORA-31523: could not find change source string for CDC change set string
Cause: The change source was missing for an imported Change Data Capture change set.
Action: Drop the imported change set because it is invalid. Verify that the schema containing the missing change source was included in the original export. If needed, perform the export again, including the schema of the missing change source.
ORA-31524: could not find change set string for CDC change table string.string
Cause: The change set was missing for an imported Change Data Capture change table.
Action: Drop the imported change table because it is invalid. Verify that the schema containing the missing change set was included in the original export. If needed, perform the export again, including the schema of the missing change set.
ORA-31525: could not find column string in CDC change table string.string
Cause: A column was missing for an imported Change Data Capture change table.
Action: It is likely that this table existed before the import operation and import did not overwrite it. Determine whether the imported change table should supercede the original table. If so, drop the original table and retry the import. If not, the change table must have a different name in order to be imported.

Above are list of Oracle Database Errors or Warnings from Error ORA-31516 to ORA-31525 received while performing certain operation against Oracle Database or related products.

What are atOracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database. Each Oracle Dabase Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.

 

Leave a Reply

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