How to fix the Oracle error ORA-02436: date or system variable wrongly specified in CHECK constraint?

In this post, you’ll learn more about the Oracle ErrorORA-02436: date or system variable wrongly specified in CHECK constraint with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-02436: date or system variable wrongly specified in CHECK constraint

Reason for the Error ORA-02436: date or system variable wrongly specified in CHECK constraint

An attempt was made to use a date constant or system variable, such as USER, in a check constraint that was not completely specified in a CREATE TABLE or ALTER TABLE statement. For example, a date was specified without the century.

How to fix the Error ORA-02436: date or system variable wrongly specified in CHECK constraint ?

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

Completely specify the date constant or system variable. Setting the event 10149 allows constraints like “a1 > ’10-MAY-96′”, which a bug permitted to be created before version 8.