Oracle Database Errors or Warnings from Error ORA-31495 to ORA-31505

SQLServerF1

ORA-31495: error in synchronous change table on “string”.”string”
Cause: There was an error originating from this synchronous change table. One possible cause is that schema redefinition has occurred on the source table and one or more columns in the change table are now a different type than corresponding source columns. Another possible cause is that there is a problem accessing the synchronous change table.
Action: Check further error messages in stack for more detail about the cause. If there has been schema redefinition, drop and recreate the synchronous change table.
ORA-31496: must use DBMS_CDC_PUBLISH.DROP_CHANGE_TABLE to drop change tables
Cause: An attempt was made to use the SQL command DROP TABLE for change tables, but DROP TABLE is not supported for change tables.
Action: Use the DBMS_CDC_PUBLISH.DROP_CHANGE_TABLE procedure instead of the DROP TABLE command.
ORA-31497: invalid value specified for first_scn
Cause: The first_scn was not greater than zero or was less than the previous value of first_scn.
Action: Check the value of first_scn. Correct it to make sure it is an integer greater than zero and greater than any previous value for this change source.

ORA-31498: description and remove_description cannot both be specified
Cause: The description and remove_description parameters were both specified.
Action: Check the values of description and remove_description. Correct call to only supply one of these values.
ORA-31499: null value specified for required parameter string
Cause: A null value was specified for a parameter that requires an explicit value.
Action: Correct call to supply a value for this parameter.
ORA-31500: change source string is not a ManualLog change source
Cause: A change source was specified that is not a ManualLog change source, but a ManualLog change source is required.
Action: Correct call to supply a ManualLog change source.

ORA-31501: change source string is not an AutoLog change source
Cause: A change source was specified that was not an AutoLog change source, but an AutoLog change source was required.
Action: Correct call to supply an AutoLog change source.
ORA-31502: invalid number supplied for supplemental_processes
Cause: The caller supplied an invalid value for supplemental_processes. The value must be a positive integer.
Action: Correct call to supply a positive integer value for supplemental_processes.
ORA-31503: invalid date supplied for begin_date or end_date
Cause: The caller supplied an invalid value for begin_date or end_date. The value must be a valid date value.
Action: Correct call to supply a valid date value for begin_date and/or end_date.
ORA-31504: cannot alter or drop predefined change source
Cause: The caller attempted to alter or drop one of the predefined change sources HOTLOG_SOURCE or SYNC_SOURCE.
Action: Do not attempt to alter or drop a predefined change source or correct call to supply the name of a user-created change source.
ORA-31505: cannot alter or drop predefined change set
Cause: The caller attempted to alter or drop the predefined change set SYNC_SET.
Action: Do not attempt to alter or drop the predefined change set or correct call to supply the name of a user-created change set.

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