disabling all the constraints in the schema

[ronnie]

Originally posted by jrpm
spool dissem
select 'Alter Table '||owner||'.'||table_name||' Disable Constraint '||constraint_name;'
from dba_constraints
order by ower,table_name;
spool off
spool enabem
'Alter Table '||owner||'.'||table_name||' Disable Constraint '||constraint_name;'
from dba_constraints order by ower,table_name;
spool off



Then edit the spool files to trim out some feedback from the queries.

Thanks a lot guys.

jrpm, I think u mean to say enable constraint.

ALso what does ur signature the answer is 42 mean. just curios :-)

Ronnie