How to fix the Oracle error ORA-02295: found more than one enable/disable clause for constraint?

In this post, you’ll learn more about the Oracle ErrorORA-02295: found more than one enable/disable clause for constraint with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-02295: found more than one enable/disable clause for constraint

Reason for the Error ORA-02295: found more than one enable/disable clause for constraint

a create or alter table specified more than one enable and/or disable clause for a given constraint.

How to fix the Error ORA-02295: found more than one enable/disable clause for constraint ?

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

only one enable or disable may be specified for a given constraint.