Re: Disable constraint cascade

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 7 Oct 1999 09:35:57 +0100
Message-ID: <939285413.23501.1.nnrp-11.9e984b29@news.demon.co.uk>

Unfortunately there is no:

enable cascade
option.

You could write a short PL/SQL procedure to enable a named constraint and then trawl recursively if necessary through XXX_constraints for any disabled constraints which depended on it, enabling as it goes.

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

dgallardo_at_my-deja.com wrote in message <7tggul$glb$1_at_nnrp1.deja.com>...
>Hi -
>
>If you use the "cascade" option when disabling a constraint ("alter
>table table_name disable constraint constraint_name cascade"), when you
>re-enable the constraint, it doesn't seem to enable any constraints for
>any other tables that it may have affected. Is this true? Is there a
>way around this?
Received on Thu Oct 07 1999 - 03:35:57 CDT