Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Validation of foreign keys
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_at_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_at_nnrp1.deja.com>,
> Mike Blake <blakemj_at_my-deja.com> 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.
Received on Fri May 05 2000 - 00:00:00 CDT