Search notes:

ORA-02290: check constraint … violated

The ORA-02290 error message is thrown if the condition of a formulated check constraint is not met.

Create a table with a few check constraints:

create table tq84_chk (
    col_1  varchar2(5)    check (col_1 = lower(col_1)),
    col_2  number  (5)    check (col_2 > 0           ),
    --
    check (length(col_1) < col_2)
);

Insert a record which violates one of the constraints:

insert into tq84_chk values ('foo', 2);

The insert statement throws ORA-02290: check constraint (RENE.SYS_C0038178) violated.

Query dba_constraints to find out which constraint was violated:

select
   owner,
   table_name,
   search_condition
from
   dba_constraints
where
   owner || '.' || constraint_name = 'RENE.SYS_C0038178';

ORA-02290: check constraint … violated

See also