Re: Discover records missed enabled FK. Why?

From: Brett Neumeier <bogus_at_address.for.spam>
Date: 1997/05/09
Message-ID: <3373968B.152C@address.for.spam>#1/1

ìÕËÁÛÅ×ÉÞ óÅÒÇÅÊ wrote:
>
> We have some Foreign Key ON DELETE CASCADE enabled in
> our database and (simultaneously we discover) some records which
> do not fit this FK.
>
> How could it be?
> Could it be reasonable to DELETE these records?
> Can anyone point me to some FAQ or commentary on this issue, please?
>
> Oracle 7.3.2

Even when a constraint is enabled -- yours may not be -- these situations can sometimes arise. I have no explanation, and neither does Oracle Support ... at least, they didn't when I asked.

I had a surreal moment a few months ago when I had a table where 33 records had NULLs in all of the primary key columns!

I suggest you just delete the offending records and check again every so often.

-bn Received on Fri May 09 1997 - 00:00:00 CDT