RE: Missing foreign key

From: Gunawan Yuwono <gunawan.yuwono_at_webbox.com>
Date: Tue, 18 Jul 2000 09:35:37 -0700
Message-Id: <10562.112289@fatcity.com>

You can enable constraint w/ NOVALIDATE option: ALTER TABLE <table_name> ENABLE NOVALIDATE CONSTRAINT <constraint_name>;

This is one reason I can think of.

HTP. Gunawan Yuwono
Oracle DBA
Kansas City, MO

>--- Original Message ---
>From: Chuck Hamilton <chuck_hamilton_at_yahoo.com>
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Date: 7/18/00 1:39:37 PM
>

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 - Free email you can access from anywhere!
>

---

Sent from a WebBox - http://www.webbox.com FREE Web based Email, Files, Bookmarks, Calendar, People and Great Ways to Share them with Others! Received on Tue Jul 18 2000 - 11:35:37 CDT