RE: Missing foreign key

From: Cale, Rick T (Richard) <RICHARD.T.CALE_at_saic.com>
Date: Tue, 18 Jul 2000 06:55:00 -0700
Message-Id: <10562.112259@fatcity.com>

Is it possible that the constraint was disabled then data was added then the constraint was
enabled with the ENFORCE option which I think only does RI constraints for all future data
not existing data. You may want to check the dba_constraints table to see what constraints
are enabled and how.

Rick

> -----Original Message-----
> From: Chuck Hamilton [SMTP:chuck_hamilton_at_yahoo.com]
> Sent: Tuesday, July 18, 2000 9:40 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Missing foreign key
>
> Anyone ever encounter a situation where you've had missing parent keys but
> the foreign key constraint is still enabled? What caused it? We have that
> situation right now on an 8i database.
>
>
>
>
>
> _____
>
> Do You Yahoo!?
> Get Yahoo! Mail <http://mail.yahoo.com/> - Free email you can access from
Received on Tue Jul 18 2000 - 08:55:00 CDT