ORA-25128:对禁用和验证了约束(...CK
我在SO中搜索，我注意到这个错误没有被覆盖。
数据库中有一个旧的表(不是我创建的)，当我尝试进行DML更改时，它抛出了这个错误。
这是我下面重现的场景。
代码语言：javascript复制drop table AM_DATA
/
create table AM_DATA
(id number(4) null,
name varchar2 (200) null)
/
alter table AM_DATA
add constraint CK_AM_DATA
check (1=1)
disable validate
/
insert into AM_DATA(id,name) values(1,'A')
/
insert into AM_DATA(id,name) values(2,'B')
/
insert into AM_DATA(id,name) values(3,'B')
/
delete AM_DATA where id =3
/
commit
/
select count(1) cnt from AM_DATA
/
SQL>
Table dropped
Table created
Table altered
insert into AM_DATA(id,name) values(1,'A')
ORA-25128: No insert/update/delete on table with constraint (....CK_AM_DATA) disabled and validated
insert into AM_DATA(id,name) values(2,'B')
ORA-25128: No insert/update/delete on table with constraint (....CK_AM_DATA) disabled and validated
insert into AM_DATA(id,name) values(3,'B')
ORA-25128: No insert/update/delete on table with constraint (....CK_AM_DATA) disabled and validated
delete AM_DATA where id =3
ORA-25128: No insert/update/delete on table with constraint (.....CK_AM_DATA) disabled and validated
Commit complete
CNT
----------
0