Re: any way to alter a constraint to make it deferrable?

From: Daniel Roy <danielroy10junk_at_hotmail.com>
Date: 2 Apr 2004 08:21:22 -0800
Message-ID: <3722db.0404020821.5096d66@posting.google.com>

> 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?

I don't understand your issue, since cascading happens only if you delete RECORDS from a parent table. If you drop this fk constraint, it won't cascade anything. Therefore, if I understand well what you try to achieve, just drop this constraint, and re-create it with the deferrable option. Just make sure that no one else inserts new (possibly invalid) records while the constraint doesn't exist. Please give at least your Oracle version when posting in the future.

Daniel Received on Fri Apr 02 2004 - 10:21:22 CST