Re: Disable All constraints from application

Davide Gurgone wrote:

>Hi All,
>I hope I'm not OT :o!
>
>I've got a problem, I need to disable temporally all constraints in one
>specific schema, but the script I do doesn't work:
>
> UPDATE USER_CONSTRAINTS
> SET STATUS = 'DISABLED'
> WHERE R_OWNER = 'OWNER'
> COMMIT;
>
>I need it to Truncate every table in my shema.
>
>If someone has got another idea, I'm happy to implement it!!!
>
>Thanks all!
>
>Davide
>
>
>

Don't ever EVER try to modify anything in the SYS or SYSTEM schema. You are lucky
your SQL statement didn't work, it couldn't because it is totally unrelated to the issue at
hand. If it had worked you'd have corrupted the database.

I can help you disable constraints ... as can others ... but what bothers me is that anyone
that would have tried what you tried should under no conditions be disabling any constraints
anywhere: You just are not qualified to make that kind of decision or to understand the
implications.

Please post the reason why you want to disable the constraints. And if it seems reasonable
someone will help you. Otherwise ... I would suggest that you should be protected from yourself.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)