Disable Constraint In Oracle. If you had created a foreign key as follows: Enabling and disabling oracle constraints can also be done with the enable and disable keywords of the constraint clause.

The disable clause causes oracle to define the constraint but not enable it. 在oracle中，可以利用alter table语句配合disable constraint使外键失效，语法为“alter table 表名 disable constraint 外键名称;”；外键失效则取消两个表数据之间链接的一列或多列。 本教程操作环境：windows10系统、oracle 11g版、dell g3电脑。 oracle怎么使外键失效. Because of the implicit commits in ddl statements like this sometimes you will.