Re: Disabling check constraints

You can also do it dinamically, using "execute immediate": BEGIN
     FOR c IN (SELECT table_name, constraint_name FROM user_constraints WHERE constraint_type = 'C' )

     LOOP
         EXECUTE IMMEDIATE 'ALTER TABLE '||c.table_name||' DISABLE
CONSTRAINT '||c.constraint_name;
     END LOOP;

More details about execute immediate can be found in "PL/SQL Guide and Reference".

Cheers,
Valentin Received on Mon Oct 16 2006 - 08:30:53 CDT