Re: Disabling check constraints

DA Morgan ha scritto:

> Alex wrote:
> > Hi all,
> > I want to be able to disable constraints, perform a number of updates,
> > then re-enabling the constraints. I need to do this because some of the
> > updates in a batch will break constraints rule
> > during the batch but by the end everything should be consistent.
>
> If you were talking about Foreign Key Constraints your request would be
> logical. But I am not aware of any means by which this could be true
> with Check Constraints.
>
> Are you sure you are asking the question you intend?
> In what version of Oracle?
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org

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.

Thanks Received on Tue Oct 17 2006 - 02:58:50 CDT