Category Archives: ORA Database Error Messages

ORA-31521: CDC subscription string already subscribes to publication ID string column string

oracle

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

Back to previous menu

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

ORA-31520: CDC subscription string already subscribes to publication ID string

oracle

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

Back to previous menu

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

ORA-31519: CDC subscription string already exists

oracle

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

Back to previous menu

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

ORA-31518: change column string already exists in CDC change table string.string

oracle

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

Back to previous menu

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

ORA-31517: CDC change table string.string already exists

oracle

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

Back to previous menu

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

ORA-31516: CDC change set string already exists

oracle

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

Back to previous menu

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

ORA-31515: CDC change source string already exists

oracle

ORA-31515: CDC change source string already exists
Cause: A Change Data Capture change source intended for import already existed
Action: Either verify that the existing change source has the desired characteristics or drop the existing change source and perform the import again

Back to previous menu

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

ORA-31514: change set string disabled due to capture error

oracle

ORA-31514: change set string disabled due to capture error
Cause: This change set has encountered a capture error and was disabled
Action: Contact the change set's publisher to request that the capture error be resolved. Subscriptions using this change set cannot be activated or have their subscription windows extended or purged until the capture error is resolved

Back to previous menu

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

ORA-31513: unsupported column type specified in change table

oracle

ORA-31513: unsupported column type specified in change table
Cause: A source column of an unsupported type was specified for inclusion in a change table. Columns types of LOB or LONG are not currently supported for change capture
Action: Change the column list so that it does not include columns of LOB or LONG types

Back to previous menu

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

ORA-31512: name cannot contain double quotation marks

oracle

ORA-31512: name cannot contain double quotation marks
Cause: A name containing a double quotation mark was supplied. Subscription names cannot contain the double quotation mark
Action: Change the name so it has no double quotation marks

Back to previous menu

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