May be the column not part of the table or column name typed wrong.

SQL> create table kk ( no number(5));

Table created.

SQL> alter table kk add constraint xcv check (no in(1,2));

Table altered.