Oracle:

SET CONSTRAINTS

SET { CONSTRAINT | CONSTRAINTS }
{ constraint [, constraint ]...
| ALL
}
{ IMMEDIATE | DEFERRED } ;

SET CONSTRAINTS ALL IMMEDIATE;

SET CONSTRAINTS emp_job_nn, emp_salary_min ,
hr.jhist_dept_fk@remote DEFERRED;

bottom of page