Re: Disable All constraints from application

"Brian Peasland" <dba_at_remove_spam.peasland.com> wrote in message news:3F96AA0B.DEC8A804_at_remove_spam.peasland.com...
> Niall gave you the answer. You have to create a script to disable your
> constraints, then run that script.

so far so good :(

> He gave you the SQL statement
> required to create the script.

as Jack points out my memory is terrible and the script I gave is just useless.

select 'alter table '||table_name||' disable constraint'||constraint_name||';'
from user_constraints
where ....

might have been rather more useful. sorry. I stand by the comparison of directly updating the data dictionary and editing the FAT table as equally daft ideas though :)

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************