Re: disabling and enabling all constraints

Hello John,

To finish with this discussion ... all you have said is true and exact and I am agree with you :-)
Just to precise that the simple sqlplus solution I gave to disable/enable constraints
is ONLY available for FOREIGN KEYS not for primary or unique keys (as you have explained)
and we use it only for that

Thanks for your clear explanation

Regards
Olivier

johnvue_at_gte.net wrote:

> First off, it is my opinion that disabling and re-enabling
> constraints is one of the most dangerous and error prone
> activities you can do in Oracle. With the following
> explanation, you'll see why.
>
> You are correct that the ordering of disable/enable
> constraints matters but there's also another little known
> caveat to the simplistic:
> select 'alter table enable constraint ... '
> from dba_constraints;
Received on Wed Aug 19 1998 - 14:39:05 CDT