Category Archives: ORA Database Error Messages

ORA-31511: name exceeds maximum length of 30 characters

oracle

ORA-31511: name exceeds maximum length of 30 characters
Cause: A name was supplied that exceeds the maximum length of 30 characters
Action: Change the name so it does not exceed 30 characters

Back to previous menu

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

ORA-31510: name uses reserved prefix CDC$

oracle

ORA-31510: name uses reserved prefix CDC$
Cause: A name was specified that starts CDC$. The name prefix CDC$ is reserved for use by Oracle Corporation
Action: Change the name so it does not start with characters CDC$

Back to previous menu

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

ORA-31509: publication does not exist

oracle

ORA-31509: publication does not exist
Cause: The specified publication did not exist or the specified subscription subscribed to a publication that no longer exists
Action: Recheck the publication or subscription specified. Either call the procedure again with an existing publication or create a new subscription that only subscribes to existing publications

Back to previous menu

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

ORA-31508: invalid parameter value for synchronous change set

oracle

ORA-31508: invalid parameter value for synchronous change set
Cause: A parameter value was specified that is not supported for synchronous change sets
Action: Correct the call to supply only valid parameter values for a synchronous change set. Synchronous change sets only support the default values for the following parameters: begin_scn, end_scn, begin_date, end_date, stop_on_ddl, supplemental_processes

Back to previous menu

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

ORA-31507: %s parameter value longer than maximum length string

oracle

ORA-31507: %s parameter value longer than maximum length string
Cause: A value was specified for a parameter that was longer than the maximum permitted length
Action: Correct the call to supply a shorter value for this parameter that fits within the maximum length

Back to previous menu

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

ORA-31506: duplicate subscription name string

oracle

ORA-31506: duplicate subscription name string
Cause: A subscription by the specifed name already exists
Action: Recreate the subscription with a unique name

Back to previous menu

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

ORA-31505: cannot alter or drop predefined change set

oracle

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

Back to previous menu

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

ORA-31504: cannot alter or drop predefined change source

oracle

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

Back to previous menu

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

ORA-31503: invalid date supplied for begin_date or end_date

oracle

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

Back to previous menu

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

ORA-31502: invalid number supplied for supplemental_processes

oracle

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

Back to previous menu

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