Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Disabling FK constraints until the end of a txn
Jonathan Lewis writes in <918210945.23480.0.nnrp-13.9e984b29_at_news.demon.co.uk>
...
>>ralfkret_at_hotmail.com wrote in message <79ee9n$8vl_at_edrn.newsguy.com>...
>>Is there any way to disable the foreign key constraints on a table until
>>the end of a transaction?
>
>Oracle 8 allows constraints to be deferred like this,
>though they have to be created as such.
>
Also in Oracle8 you can set differable/immediate constraint checking for all constraint within your session
SET ALL CONSTRAINTS DEFERRED; SET CONSTRAINT constraint_name DEFERRED; SET ALL CONSTRAINTS IMMEDIATE; SET CONSTRAINT constraint_name IMMEDIATE;
Valery Yourinsky Received on Fri Feb 05 1999 - 11:19:46 CST