ORA-00001: 违反唯一约束条件 (IDS.SYS_C0016812)
看后台窗口报错信息是某个表批量插入时报错。于是查找该表是否有自增序列。
select SEQUENCE_OWNER,SEQUENCE_NAME from dba_sequences where sequence_owner=’***’;
select SEQ_ID.nextval from dual;
select a.,b.
from user_constraints a inner join user_cons_columns b on a.table_name=b.table_name
where a
原创
2021-04-15 21:58:38 ·
1178 阅读 ·
0 评论