Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.stanford.edu!sn-xt-sjc-02!sn-xt-sjc-09!sn-post-sjc-01!supernews.com!corp.supernews.com!not-for-mail From: Walt Newsgroups: comp.databases.oracle.server Subject: Re: Integrity constraint violated Date: Tue, 08 Aug 2006 09:15:11 -0400 Organization: Corwood Industries Message-ID: <12dh3j0eeeglp1d@corp.supernews.com> Reply-To: walt_askier@SHOESyahoo.com User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.2) Gecko/20040804 Netscape/7.2 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 References: <1155031051.370417.300980@i42g2000cwa.googlegroups.com> <1155035976.755739.76650@h48g2000cwc.googlegroups.com> <1155036819.687564.143660@i42g2000cwa.googlegroups.com> <1155038126.938542.263170@m79g2000cwm.googlegroups.com> <1155038488.494618.281050@b28g2000cwb.googlegroups.com> In-Reply-To: <1155038488.494618.281050@b28g2000cwb.googlegroups.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@supernews.com Lines: 17 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:272362 mamin@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