Re: disabling and enabling all constraints

From: Winnie Liu <poohland_at_hotmail.com>
Date: Sun, 16 Aug 1998 19:43:42 -0700
Message-ID: <6r854i$lku@sjx-ixn6.ix.netcom.com>

I think I have the same question on my head. why enable all the constraints later (after disable it) will not work with the storage clause that are used to created the constraint (mostly the primary key and unique key index)?

Thanks

Winnie

Olivier Bercovitz wrote in message <35D6EE56.96E1197_at_club-internet.fr>...
>Hello John,
>
>Why this script won't work for constraint with associated index ??
>because of the order of the constraint to disable ??
>
>thanks for the answer
>
>
>johnvue_at_gte.net wrote:
>
>> Just remember though, if any constraint was made using a STORAGE
>> clause to create the associated index in another tablespace or change
>> other parameters, this "simple" script won't work.
>>
>>
>
Received on Sun Aug 16 1998 - 21:43:42 CDT