Does anyone know what is the command to disable foreign key constraint? Thanks.
alter table "table1" disable constraint "constraint_name";
alter table modify constrain FK_CONST disable [validate/nivalidate].
If you disable a unique or primary key constraint that is using a unique index, Oracle drops the unique index.