一、创建主从表
conn scott/tiger
create table t1 as select * from dept;
create table t2 as select * from emp;
alter table t1 add constraint pk_dept$deptno primary key(deptno);
alter table t2 add constraint fk_emp$deptno foreign key(deptno) references t1(deptno);
select table_name,constraint_name,constraint_type
from user_constraints
where table_name in('T2','T1');
TABLE_NAME
-------------------- ------------------------------ --------------------
T1
T2
二、设置约束状态为 disable validate
alter table t2 disable validate constraint FK_EMP$DEPTNO;
SQL> delete from t1;
已删除4行。
SQL> delete from t2;
delete from t2
*
第 1 行出现错误:
ORA-25128: 不能对带有禁用和验证约束条件 (SCOTT.FK_EMP$DEPTNO) 的表进行插入/更新/删除
SQL> update t2 set empno=123;
update t2 set empno=123
*
第 1 行出现错误:
ORA-25128: 不能对带有禁用和验证约束条件 (SCOTT.FK_EMP$DEPTNO) 的表进行插入/更新/删除
SQL> insert into t2 select *from t2;
insert into t2 select *from t2
*
第 1 行出现错误:
ORA-25128: 不能对带有禁用和验证约束条件 (SCOTT.FK_EMP$DEPTNO) 的表进行插入/更新/删除
三、结论