Oracle Database Errors or Warnings from Error ORA-31526 to ORA-31535

SQLServerF1

ORA-31526: could not find source table string.string for CDC change table string.string
Cause: The source table was missing or was not set up correctly for an imported Change Data Capture change table. A synchronous change table requires the source table to exist and have the Change Data Capture trigger defined on it. An asynchronous change table requires table rules to be defined for the source table.
Action: Drop the imported change table because it is invalid. Verify that the schema containing the source table was included in the original export. If needed, perform the export again, including the schema of the source table. If change table is asynchronous, ensure that STREAMS_CONFIGURATION=y is specified for the import.
ORA-31527: could not find source column string for CDC change table string.string
Cause: A source column 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 source table was included in the original export. If needed, perform the export again, including the schema of the missing source table.
ORA-31528: could not find change set string for CDC subscription string
Cause: The change set was missing for an imported Change Data Capture subscription.
Action: Drop the imported subscription 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-31529: could not find publication for CDC subscriber view string.string
Cause: A publication was missing for an imported Change Data Capture subscription.
Action: Drop the imported subscription because it is invalid. Verify that the schema containing the missing publication was included in the original export. If needed, perform the export again, including the schema of the missing publication.
ORA-31530: could not find published column string for CDC subscriber view string.string
Cause: A published column was missing for an imported Change Data Capture subscription.
Action: Drop the imported subscription because it is invalid. Verify that the schema containing the missing published column was included in the original export. If needed, perform the export again, including the schema of the missing published column.
ORA-31531: could not find column string in CDC subscriber view string.string
Cause: A column was missing in a subscriber view for an imported Change Data Capture subscription.
Action: It is likely that this view existed before the import operation and import did not overwrite it. Determine whether the imported subscriber view should supercede the original view. If so, drop the original view and retry the import. If not, the subscriber view must have a different name in order to be imported.

ORA-31532: cannot enable change source string
Cause: The change source cannot be enabled when there is no change table created in any of the change sets associated with the change source.
Action: Add a change table to a change set before enabling the the change source.
ORA-31533: only one change set (string) is allowed in change source
Cause: A Distributed HotLog change source can contain at most one change set.
Action: Create a new change source and create the change set in the new change source.
ORA-31534: Change Data Capture string publisher string is missing DBA role
Cause: The publisher does not have the DBA role, which is required by the Change Data Capture operation.
Action: Grant the DBA role the Change Data Capture publisher.
ORA-31535: cannot support change source string in this configuration
Cause: 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.
Action: Remove the existing change source and create this new change source again.

Above are list of Oracle Database Errors or Warnings from Error ORA-31526 to ORA-31535 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 *