-- disable foreign key
alter table my_table disable constraint mytbl_col_othr_tbl_col_fk;

-- enable foreign key
alter table my_table enable constraint mytbl_col_othr_tbl_col_fk;