From: Roby Sherman Subject: Re: Validation of foreign keys Date: 2000/05/05 Message-ID: <39134E70.9C278EED@uswest.net>#1/1 Content-Transfer-Encoding: 7bit References: <8es6j9$679$1@nnrp1.deja.com> <8es9dd$9oc$1@nnrp1.deja.com> X-Accept-Language: en Content-Type: text/plain; charset=us-ascii X-Trace: news.uswest.net 957566881 63.225.125.238 (Fri, 05 May 2000 17:48:01 CDT) Organization: Interealm MIME-Version: 1.0 NNTP-Posting-Date: Fri, 05 May 2000 17:48:01 CDT Newsgroups: comp.databases.oracle.misc Let's clarify this a bit. It will "check" the dictionary to figure out which constraints might need validation, but it doesn't actually validate constraints on columns that weren't affected by the update... That would be a horrendous waste of resources. --Roby marcpark@my-deja.com wrote: > If you have constraints enabled (It has to be set up as constraint) > enabled, then Oracle will check all constraints to ensure they are > correct. > > Marc Parkinson > Oracle Developer > > In article <8es6j9$679$1@nnrp1.deja.com>, > Mike Blake wrote: > > I have been trying to find out if Oracle will validate all foreign keys > > in a table during an update. I have a table wit a lot (37) foreign > > keys. The majority are not required. The process that exists for > > populating the table added foreign keys as the user progresses through > > the application. So, the insert of the row will have only the required > > 3 foreign keys. When the user updates the row, will Oracle validate > > only the newly added/changed foreign keys or validate all the foreign > > keys? > > > > Any ideas? > > > > TIA > > > > Mike Blake > > > > Sent via Deja.com http://www.deja.com/ > > Before you buy. > > > > Sent via Deja.com http://www.deja.com/ > Before you buy.