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>
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