Category Archives: ORA Database Error Messages

ORA-31501: change source string is not an AutoLog change source

oracle

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

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31500: change source string is not a ManualLog change source

oracle

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

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31499: null value specified for required parameter string

oracle

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

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31498: description and remove_description cannot both be specified

oracle

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

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31497: invalid value specified for first_scn

oracle

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

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31496: must use DBMS_CDC_PUBLISH.DROP_CHANGE_TABLE to drop change tables

oracle

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

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31495: error in synchronous change table on “string”.”string”

oracle

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

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31494: could not activate a LogMiner session

oracle

ORA-31494: could not activate a LogMiner session
Cause: Failure during activation of a LogMiner session while advancing an asynchronous change set. This is an internal error
Action: Contact Oracle Corporation

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31493: could not prepare session for LogMiner session

oracle

ORA-31493: could not prepare session for LogMiner session
Cause: Failure during prepare session for a LogMiner session while advancing an asynchronous change set. This is an internal error
Action: Contact Oracle Corporation

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31492: could not set session parameters for LogMiner session

oracle

ORA-31492: could not set session parameters for LogMiner session
Cause: Failure during set parameters for a LogMiner session while advancing an asynchronous change set. This is an internal error
Action: Contact Oracle Corporation

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/