How to fix the Oracle error ORA-26890: Invalid update LCR on Oracle Sequence “string”.”string”?

In this post, you’ll learn more about the Oracle ErrorORA-26890: Invalid update LCR on Oracle Sequence “string”.”string” with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-26890: Invalid update LCR on Oracle Sequence “string”.”string”

Reason for the Error ORA-26890: Invalid update LCR on Oracle Sequence “string”.”string”

The new value column list of an update LCR on an Oracle Sequence did not have non-null columns “CYCLE#”, “INCREMENT$”, “CACHE” and “HIGHWATER”.

How to fix the Error ORA-26890: Invalid update LCR on Oracle Sequence “string”.”string” ?

You can fix this error in Oracle by following the below steps

Make sure the new value column list has all the required columns. This might be a user error if the LCR is from an XStream In client.