Oracle: disable and enable a constraint 

Joined:
04/09/2007
Posts:
565

February 18, 2010 21:04:13
-- 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;
[ Comment  | Tags ]
 
Easy email testing with http://www.ximailstop.com