How to fix the Oracle error ORA-14764: FOR VALUES clause cannot be specified for only one partition?

In this post, you’ll learn more about the Oracle ErrorORA-14764: FOR VALUES clause cannot be specified for only one partition with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-14764: FOR VALUES clause cannot be specified for only one partition

Reason for the Error ORA-14764: FOR VALUES clause cannot be specified for only one partition

An attempt was made to specify the FOR VALUES clause for only one of the two partitions being merged.

How to fix the Error ORA-14764: FOR VALUES clause cannot be specified for only one partition ?

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

Specify a FOR VALUES clause for each of the two partitions being merged or do not specify the FOR VALUES clause for either.