不论是修改还是添加约束添加 exceptions这个对象对应的字段有
如果给一个表添加约束条件
create table constTable_1
as select t.id,t.code from thd_stkstockin t;
create table const_exceptions
(
row_id rowid,
onwer varchar2(100),
tablename varchar2(100),
constraint varchar2(100)
);
insert into constTable_1 select t.id,t.code from thd_stkstockin t;
delete const_exceptions;
alter table constTable_1 add constraint const_pr_1 primary key(id) exceptions into const_exceptions;
或者
alter table constTable_1 add constraint const_pr_1 primary key(id) disable ;
alter table constTable_1 enable validate constraint const_pr_1 exceptions into const_exceptions;
从而得到了违反约束条件的记录,通过rowid直接找到对应的行