Re: Temporarely disabeling constraints

I believe the syntax your are looking for is;

 alter table <table_name> disable constraint <constraint_name>;

with enable replacing disable for the reverse operation.

If you are unsure of the constraint_name you require, al list of all the constraints for the current user can be found in the user_constraints view, alternatively if the current user is not the table ower the all_constraints view lists all constraints accessible by the user.

Hope this helps,

Ian Received on Thu Oct 16 1997 - 00:00:00 CDT