Re: Disabling check constraints

From: Alex <alexadri83_at_virgilio.it>
Date: 17 Oct 2006 01:32:31 -0700
Message-ID: <1161073951.345146.191710@i3g2000cwc.googlegroups.com>

Thomas Kellerer ha scritto:

> On 17.10.2006 09:58 Alex wrote:
> > Oracle version is 9.2 but I'm looking for something that works with any
> > version...
> > I need to update some key values on tables that have Foreign Key
> > Constraints.
> > What should I do?
> >
> > I don't know exactly what's the problem... DBMS returns this error
> > message: "integrity constraint violated - child record found" when I
> > try to update the key value on a parent table. So I want to disable
> > that I call "check" on foreign key constraints.
>
> What about my suggestion about setting the constraints to
> deferrable/initially deferred, so that they will be validated at the end
> of the transaction?
>
> Thomas

I'm using SQL*Plus... I tried it but returns the same error. I've read something about "begin work" & "commit work"... but don't works anyway.

SQL> begin work;
  2 SET CONSTRAINTS ALL DEFERRED;
  3 update entity set id_entity=id_entity+10000;   4 commit work;
  5 /

What I have to write? Received on Tue Oct 17 2006 - 03:32:31 CDT