Oracle Error ORA-31469: cannot enable Change Data Capture for change set string

Oracle Error Message

ORA-31469: cannot enable Change Data Capture for change set string

Reason for the Error

The change set has reached the specified limit that was set up by the CREATE_CHANGE_SET command.

Solution

Check the alert log to find out whether capture, apply or both reached the limit. Once apply reaches its limit, the change set is permanently disabled. Create a new change set with new limits to continue capturing data.