Re: anyway to alter a constraint to make it deferrable?

Ryan Gaffuri wrote:
>
> I don't want to drop and re-create it, since there are cascading
> foreign keys. I don't see it in the docs.
>
> alter table x modify (constraint x_fk deferrable);
>
> I cant find the proper syntax?

Straight from the Oracle docs:

"You cannot change the state of a NOT DEFERRABLE constraint to INITIALLY DEFERRED." Otherwise, remove the parentheses in your syntax....

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"