We have a requirement to update the common user (C##USER1) on source connection with new user name (C##USER2) for existing CDC extract. But when I updated the user, extract ABENDED with below error.
"2021-11-30 12:01:03 ERROR OGG-02040 Extract USERID or TRANLOGOPTIONS MININGUSER C##USER2 does not match the logmining server connect user C##USER1.",
"",
How to resolve the issue other than unregistering extract and registering it again. looking for other alternatives.