Re: Integrity constraint violated

From: Walt <walt_askier_at_SHOESyahoo.com>
Date: Tue, 08 Aug 2006 09:15:11 -0400
Message-ID: <12dh3j0eeeglp1d@corp.supernews.com>

mamin_at_o2.pl wrote:

>>Not very likely.
>>Oracle doesn't generate constraints automatically.
>>If it did generate constraints, it is because you or someone else, is
>>using Designer, and instructed it do to so.

> 
> Well, I'm sure that it was generated automatically.The only one tool
> I'm using is TOAD.Maybe this tool can do such things either.

TOAD doesn't generate constraints automatically either, unless you consider clicking on the "create constraint" button and filling out the relevant information in the dialog box to be "automatic". Somebody specified the constraint. If it's incorrect from a business rule perpective, you need to change it.

//Walt Received on Tue Aug 08 2006 - 08:15:11 CDT