ORA-02447: cannot defer a constraint that is not deferrable 报了这个异常
02447, 00000, "cannot defer a constraint that is not deferrable" // *Cause: An attempt was made to defer a nondeferrable constraint // *Action: Drop the constraint and create a new one that is deferrable看来,只有先drop再create之,并在create时指定deferrable initially deferred
add constraint FK_NAME foreign key (COLNAME)
references table_name2 (COLNAME2)
deferrable initially deferred;
这个外键约束是已经存在的
能不能在不改动这个外键约束的情况下满足需求呢?
比如设置session的某个属性?如果没有的话 请告诉我如何改动这个约束呢?
报了这个异常
// *Cause: An attempt was made to defer a nondeferrable constraint
// *Action: Drop the constraint and create a new one that is deferrable看来,只有先drop再create之,并在create时指定deferrable initially deferred
不过我决定先disable再enable
谢了