Search notes:

ORA-02293: cannot validate (.) - check constraint violated

Preparation

create table tq84_t(a number);

begin
   insert into tq84_t values ( 1);
   insert into tq84_t values ( 2);
   insert into tq84_t values ( 3);
   insert into tq84_t values (-4);
   insert into tq84_t values ( 5);

   commit;
end;
/

The following statement throws ORA-02293: cannot validate (RENE.TQ84_T_CK) - check constraint violated:

alter table tq84_t add constraint tq84_t_ck check (a > 0

Cleaning up:

drop table tq84_t;

ORA-02293: cannot validate (.) - check constraint violated

See also