-- ----------------------------------------------------------------------------------- -- File Name : http://oracle-base.com/dba/constraints/disable_chk.sql -- Author : Tim Hall -- Description : Disables all check constraints for a specified table, or all tables. -- Call Syntax : @disable_chk (table-name or all) (schema-name) -- Last Modified: 28/01/2001 -- ----------------------------------------------------------------------------------- SET PAGESIZE 0 SET FEEDBACK OFF SET VERIFY OFF SPOOL temp.sql SELECT 'ALTER TABLE "' || a.table_name || '" DISABLE CONSTRAINT "' || a.constraint_name || '";' FROM all_constraints a WHERE a.constraint_type = 'C' AND a.owner = UPPER('&2'); AND a.table_name = DECODE(UPPER('&1'),'ALL',a.table_name,UPPER('&1')); SPOOL OFF -- Comment out following line to prevent immediate run @temp.sql SET PAGESIZE 14 SET FEEDBACK ON SET VERIFY ON