cannot validate FK - parents not found

From: timo <timo.talja_at_luukku.com>
Date: Fri, 19 Sep 2008 07:56:03 GMT
Message-ID: <nWIAk.43$ep2.0@read4.inet.fi>


Hi,
what's the most efficient way to search rows in a (big) table preventing FK to be created;
we've a table where PK consists of several columns and those columns are referenced by child tables.

And as the table has already rows with problems those should be identified easily and corrected - so now we get
ORA-02298: cannot validate (AAA.BBBBB_FK) - parent keys not found

BR, Timo Received on Fri Sep 19 2008 - 02:56:03 CDT

Original text of this message